Countif

[abhisek99]

How can i write this function .When i want to (for e.g) count the number
of patients with malaria,
number of patients with Aids,
Number of normal patients

with in the range of ages 5-10,10-15,15-20
Please help me .I am a Doctor and have only little information on
Excel.

 

[Don Guillett]

Have a look in HELP index for COUNTIF

 

[Mark Graesser]

This formula is adapted from a response to "multi criteria for countif" by J.E. McGimpsey on 10/1/2003

The following formula is a common way to do a COUNTIF using multiple criteria. I set this up assuming the description (malaria,AIDS...) is in column A and the patients age is in column B. The first part (A1:A20=E1) checks each entry in column A and compares it to E1, this is where you can enter the description you want to count, or you could replace E1 with "malaria". The second part sets the minimum age and the last sets the maximum. Again you could replace the cell references with the actual age numbers

=SUMPRODUCT(--(A1:A20=E1),--(B1:B20>=F1),--(B1:B20<=G1)

Good Luck
Mark Graesse
(e-mail address removed)

----- abhisek99 wrote: ----


How can i write this function .When i want to (for e.g) count the numbe
of patients with malaria
number of patients with Aids
Number of normal patient

with in the range of ages 5-10,10-15,15-2
Please help me .I am a Doctor and have only little information o
Excel