Thread
:
How to od a combined IF and AND in a matrix formula
View Single Post
#
2
Arvi Laanemets
Posts: n/a
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
Reply With Quote