Thread: SumIf
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
juanpablo juanpablo is offline
external usenet poster
 
Posts: 108
Default SumIf

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