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.



"kristap" wrote:

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?

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"kristap" wrote in message
...
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")