Forum Discussion
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 column E, text "*italija*", what I have to write in citeria of column A? "*" is not working :(
=SUMIFS(Pivot_18!$A:$A, "*" , Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
When better SUMPRODUCT
=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))
Hi Karolis,
Nothing, A is your sum range
=SUMIFS(Pivot_18!$A:$A, Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
- 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*")
