Hi, Ashish:

Okay, thanks for the suggestion.

Now, the real tricky part I've been trying to figur out is that the column
I'm trying to sum up (in col A for example) could contain negative values.
SO, IF the SUM still end up to be a negative value, then I need to show a 0
(or blank). I already have created some simple pivot tables from this
spreadsheet. But does not look like the cell value can still be changed once
it is in the pivot table data area. Thus, thinking I may need to add
additional columns in the souce spreacsheet and do the manipulation there
first ?

Felicia
"Ashish Mathur" wrote:

Hi,

You can create a simple pivot table - drag column c and d to the row field
area and column b to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Felicia" wrote in message
...
Hi, I see your response to Michelle and I'm trying to do something very
similar. Except I need to a combination of criteria.

I got the SUMIF(B:B,C1,A:A) part myself already. But, I need to check
another column. So, basically do the SUM (subtotal) by Col B and Col C.

Say the table looks like this:

a b c d
1 .2 service1 managerA .3
2 .5 service2 managerB .5
3 .1 service2 managerA 0
4. .5 service2 managerB 0.1
5. .3 service1 managerA 0.1

And I need the SUM for
Service 1 managerA
Service2 managerA
Service 1 managerB
Service2 managerB

I can not do simple sort & subtotal as this is part of a bigger
spreadsheet;
and there are other calculations.

THANKS !



"Max" wrote:

"michelle" wrote:
Thank you. That worked perfectly.

Glad to hear that !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---