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.

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

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?


--
Biff
Microsoft Excel MVP


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

Yes - thank you it worked.

"Simon Lloyd" wrote:


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

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" wrote:

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?


--
Biff
Microsoft Excel MVP


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

Ok, thanks for feeding back!

--
Biff
Microsoft Excel MVP


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

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?


--
Biff
Microsoft Excel MVP


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