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)))
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!
you are welcome