Forum Discussion
Solved
COUNTIFS function
Hello,
I need to count cells with any number on it in column A, but there is few criteria, I need to count only theese numbers which has in the same row but in column F text "saus" and in the c...
When better SUMPRODUCT
=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))
sorry, it had to be COUNTIFS(Pivot_18!$A:$A, "*" , Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
If you have no criteria for column A when
=COUNTIFS(Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
- acually I have, it should be counted if there is any number on it.
When better SUMPRODUCT
=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))- thank you, works perfect!