Feb 26 2018
07:29 AM
- last edited on
Jul 25 2018
11:11 AM
by
TechCommunityAP
Feb 26 2018
07:29 AM
- last edited on
Jul 25 2018
11:11 AM
by
TechCommunityAP
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*")
Feb 26 2018 07:39 AM
Hi Karolis,
Nothing, A is your sum range
=SUMIFS(Pivot_18!$A:$A, Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
Feb 26 2018 07:43 AM
Feb 26 2018 07:56 AM
If you have no criteria for column A when
=COUNTIFS(Pivot_18!$F:$F, "saus", Pivot_18!$E:$E, "*italija*")
Feb 26 2018 07:59 AM
Feb 26 2018 08:08 AM - edited Feb 26 2018 08:09 AM
SolutionWhen better SUMPRODUCT
=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))
Feb 26 2018 08:08 AM - edited Feb 26 2018 08:09 AM
SolutionWhen better SUMPRODUCT
=SUMPRODUCT(ISNUMBER(Pivot_18!$A:$A)*(Pivot_18!$F:$F = "saus")* ISNUMBER(SEARCH("italija",Pivot_18!$E:$E)))