SUM of values within date range which equals another field

J

Jennifer_3124

Hi,

Can someone please help me out.. I have gone thru this forum and hav
found a kinda right solution but mine is abit different.

Basically its like for hospital data:

I have say a date range say between 01/01/2002(start_date) an
01/04/2004 (end_date)

Need to know how many patients (patient_ID) are admitted into
parituclar department (heart_dept) within the above date range.

If someone can help me would be really great :
 
F

Frank Kabel

Hi
if column A stores the date and column B the department use
=SUMPRODUCT(--(A1:A1000>=DATE(2002,1,1)),--(A1:A1000<DATE
(2004,4,1)),--(B1:B1000="heart department))
 

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

Finding Dates in a date range 1
Sum one field if another field is equal to something 10
Summing rows based on other column values 7
Excel VBA - Delete rows within a date range 9
Finding dates within a date range 2
calculations within a date range 2
Macro to sum array by date 5
sum of info in a range based on dates 4

Top