Always with the SUMPRODUCT questions!

M

MarianneR

Those were just made up numbers. I want to select all of the cases wit
Diagnoses ABC, for the first review and During the month of March.
After finding these cases, I want to add the TOTALpresent...

Eventually, my table will have the TOTALpresent/TOTALpossible, givin
me a percentage.

Marianne:cool
 
D

duane

assuming your data is in columns a-f as shown, with header row in row 1

total present for abc, 1st review in march

=sumproduct((b2:b5="abc")*(c2:c5="1st")*(d2:d5="mar-04")*(e2:e5))

note if column d are dates and not text we may have to adjust this

if you build a table like you showed, you can substitute the cell
which have the criteria for "abc", "1st", etc
 
Top