Sum of datas with multiple conditions

[einna77]

I need help.

I want to know how many of this sample data contains blue (in column A), xl,s, and L (in column B), blanks (in column C) , blanks (in column D),

In this sample, the answer should be 2.

I hope you can help me. Thank you.

 

[FormR]

Hi, you could try:

=SUM(COUNTIFS(A:A,"BLUE",C:C,"",D:D,"",B:B,{"XL","S","L"}))

 

[einna77]

Hi, you could try:

=SUM(COUNTIFS(A:A,"BLUE",C:C,"",D:D,"",B:B,{"XL","S","L"}))

Thanks.
Can i also use this formula in google sheet?

 

[FormR]

Can i also use this formula in google sheet?

Hi, you could try, but I don't really know to be honest.

 

[einna77]

Hi, you could try, but I don't really know to be honest.

It does work in excel but not in google sheet anyways. Thank you so much this is such a big help.

 

[FormR]

but not in google sheet

You could try like this in google sheets, which I think will work, but I'm not familiar enough with google sheets to know if there is a better way.

=SUMPRODUCT(--(A1:A1000="BLUE"),--(C1:C1000=""),--(D1:D1000=""),--ISNUMBER(MATCH(B1:B1000,{"XL","S","l"},0)))

 

[einna77]

You could try like this in google sheets, which I think will work, but I'm not familiar enough with google sheets to know if there is a better way.

=SUMPRODUCT(--(A1:A1000="BLUE"),--(C1:C1000=""),--(D1:D1000=""),--ISNUMBER(MATCH(B1:B1000,{"XL","S","l"},0)))

Yes! It works! Thank you so much!!