Sum IF ?

[kristap]

I need to add on to my question from the other night. Here is the example

A B C
Count Size Type
2 4x8 EPS
0 4x2 HD
2 3x4 CD

I need a calculation where it says "Yes" in the cell (not a number) for all
the HD and the CD.... HD is 0 but I still need the yes because there is a
CD....This is what i have but how do I get it to figure the cd as well?
E12:E23 is the type and A12:A23 is the count. I have tried a few different
things to add in the CD part but none seem to work for me.
=IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)>0,"Yes","None")

 

[T. Valko]

=IF(SUMIF(Barrett!E12:E23,"HD",Barrett!A12:A23)>0,"Yes","None")

Maybe this:

=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23),"Yes","None")

 

[kristap]

I tired it and it said "Your formula is missing --) or (. Check the formula
and add in the appropiate place... I tried adding in a parenthesis at the end
but it said my formula contained an
error....=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23),"Yes","None"))

Do I need the (SUM and the (Sumif?

 

[Teethless mama]

This formula should work

=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23)),"Yes","None")

Do I need the (SUM and the (Sumif?

yes, you do.

 

[T. Valko]

Ooops! My mistake. I forgot the closing ")" for the SUM function.

Try it like this:

=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23)),"Yes","None")

 

[kristap]

I tired that and it said i didn't have enough --) or (. so i added a
parenthesis at the end and it didn't work, said the formula contained an
error. This is what I have
=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23),"Yes","None"))

 

[T. Valko]

Ooops! My mistake. I forgot the closing ")" for the SUM function.

Try it like this:

=IF(SUM(SUMIF(Barrett!E12:E23,{"CD","HD"},Barrett!A12:A23)),"Yes","None")

 

[kristap]

Awesome, Thank you so much....... Thanks to you too toothless momma.....
I appreciate all your help

 

[T. Valko]

You're welcome. Thanks for the feedback!