I'm sure that would work but I couldn't get it to with my limited knowledge. However after poking around, I did get an if statement to calculate each table for me and then I used sum to add each to get to my total count. Probably the long way around but it works. Here's my next question if you can help.
I want to take the sum (Raw) and divide by the Count (Avail) to get a Score. I thought that was pretty simple but I get the following error using this. - but it still gives me the correct answer. I would like to get rid of this error box. Any help would be great.