How to od a combined IF and AND in a matrix formula

[Guest]

Hi,

What I want to do is counting a sum based on fulfilment of two criterias

=SUM(IF(AND(A1:A10=F1;B1:B10=F2);SUM(C1:C10))

Regards

murphy

 

[Arvi Laanemets]

Hi

=SUMPRODUCT(--(A1:A10=F1);--(B1:B10=F2);C1:C10)


Arvi Laanemets

 

[Guest]

Here are two options:

The count of all C's that fullfill the A and B criterias.
=SUMPRODUCT((A1:A10=F1)*(B1:B10=F2))

The sum...
=SUMPRODUCT((A1:A10=F1)*(B1:B10=F2)*(C1:C10))

Hope it helped
Ola Sandström

 

[Guest]

Hi,

Try this

SUM(IF((a1:$a$10=f1)*(b1:$b$10=f2),c1:c10))

Regards,