Hello,

If I have the following Pivot Table:

PRODUCT WEEK1 WEEK2 WEEK3
X 32 12 4
Y 34 98 54
Z 6 2 9

And I want to add only X and Y for each week, how can I do it?
Remember this is a Pivot Table, so the products can change and they will not
always be in the same row, so SUM wont work.

JP

XL won't care what row it is in as long as it is always in the same column:

=SUMIF(A2:A4,"X",B2:B4)+SUMIF(A2:A4,"Y",B2:B4)

or:

=SUMPRODUCT((A2:A4={"X","Y"})*B2:B4)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"juanpablo" wrote in message
...
Hello,

If I have the following Pivot Table:

PRODUCT WEEK1 WEEK2 WEEK3
X 32 12 4
Y 34 98 54
Z 6 2 9

And I want to add only X and Y for each week, how can I do it?
Remember this is a Pivot Table, so the products can change and they will
not
always be in the same row, so SUM wont work.

JP