I'm not sure how to do what i need to do. I think it will be easier to
explain if I do an example

A B C
count size type
43 4x4 XPS
1 4x8 EPS
3 4x4 Comp
0 4x8 EPS
2 3x2 XPS


Ok on a separate worksheet I need to Add all the XPS and if there are any
(anything greater than 0) then on the other sheet I need it to say "yes". The
worksheet is going to be just a quick glance instead of going in to all the
separate warehouses...... So in the example, EPS has 0 so it wouldn't say
anything, it would remain blank. I hope this makes sense.