SumIf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top