Thread: How to od a combined IF and AND in a matrix formula
View Single Post
  #1   Report Post  
murphyfilur
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote