Count If ?

L

Lesotho

Can i use the countif function with multiple conditions.

i.e. if Range a = value + range b = value then sum Range c

If not any ideas on how i do this.

Many thank
 
J

JulieD

Hi

you need to use the SUMPRODUCT function
=SUMPRODUCT((A1:A100="A")*(B1:B100="B"))
for counting
for summing
=SUMPRODUCT((A1:A100="A")*(B1:B100="B")*(C1:C100))

hope this helps
Cheers
JulieD
 
Top