Im not sure what you mean?, if you want to sum the total for XPS then
use =SUMIF(C1:C5,"XPS",A1:A5) (assuming your range is only 5 rows deep)
if you want it to simply put yes or none then use
=IF(SUMIF(C1:C5,"XPS",A1:A5)0,"Yes","None"), is this what you wanted?
kristap;405996 Wrote:
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.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113190