Sum the values in a Column depending on values in two other col.

[MarioMiranda]

StudentID Sex Age CollectionAmount
A Male 11 21
B Male 11 22
C Female 8 23
D Female 12 24
E Female 9 25


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

 

[Tim Otero]

Provided cells used are A16, the formula would be:

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

entered as and array formula, using ctrl+shift+enter instead of just enter

tim

 

[Stephen]

Create another column and put in =if((c1>10),d1,0), then
take the sum of that column. There may be a way to do it
through one formula, but I'm not sure how.