Help please - not sure

[kristap]

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]

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?

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)

 

[T. Valko]

EPS has 0 so it wouldn't say anything, it would remain blank.

EPS has 2 entries:

1...4x8...EPS
0...4x8...EPS

So why would EPS remain blank?

 

[kristap]

Yes - thank you it worked.

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?



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[kristap]

You are right, it wouldn't be blank. In the example, I didn't mean to put 2
EPS, I thought I had only done the one with the 0. Which the 0 would have
been blank, but I didn't mean to put the 1 for EPS in there.... sorry....

What the previous poster put worked.

 

[T. Valko]

Ok, thanks for feeding back!