Always with the SUMPRODUCT questions!

  • Thread starter Thread starter MarianneR
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Always with the SUMPRODUCT questions! 4
sumproduct and weekday? 19
Sumproduct question 2
Always with the SUMPRODUCT questions! 1
Average with 2 criteria including month 8
SumProduct - With Or Function 2
Sumproduct, 3 columns and date 3
Using Sumproduct Function To Add Multiple Criteria 1

Back
Top