SOLVED

COUNTIFS function

Copper Contributor

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*")

7 Replies

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*")

 

acually I have, it should be counted if there is any number on it.
best response confirmed by Karolis D (Copper Contributor)
Solution

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

1 best response

Accepted Solutions
best response confirmed by Karolis D (Copper Contributor)
Solution

When better SUMPRODUCT

=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))

 

View solution in original post