Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to od a combined IF and AND in a matrix formula
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 |
#2
|
|||
|
|||
Hi
=SUMPRODUCT(--(A1:A10=F1);--(B1:B10=F2);C1:C10) Arvi Laanemets "murphyfilur" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Hi,
Try this SUM(IF((a1:$a$10=f1)*(b1:$b$10=f2),c1:c10)) Regards, "murphyfilur" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|