formula in a worksheet

[Usha]

I am trying to count the no of rows that satisfy multiple
conditions. I tried using COUNIF and SUMIF with no luck.
If anyone could help, that would be appreciated.

 

[Manik]

Here is an example of what I did:
A B C D
------------------------------------------------
1| StudentID Sex Age CollectionAmount
2| A Male 11 21
3| B Male 11 22
4| C Female 8 23
5| D Female 12 24
6| E Female 9 25


Formula to find the sum of "CollectionAmount" for Male
Students of Age > 10

Provided cells used are A16, the formula would be:

=SUM((B2:B6="Male")*(C2:C6>10)*D26)

I ran into the same problem before and got the answer tru
this group but posted it in "Worksheet Functions" section
of "Excel"

 

[Walt Weber]

Hi Usha & Manik,

You both need the function DSUM(database,field,criteria)
with the criteria set for the multiple defined
conditions. Check the help system.

Manik, in your case, the function would be "=DSUM
(A16,$D$1,G1:H2)" if G1 is 'Sex' and H1 is 'Age' and G2
is 'Male' and H2 is '>10'.

Usha, yours should be similar.

Best Regards,
Walt