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