View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eucalypta Eucalypta is offline
external usenet poster
 
Posts: 29
Default Formula in combination with pivot table

Dear all,

Kind of new to pivot tables and hoping that someone out there is able to
help me ;-).

I have a pivot table that generates in colom A country names and in row 2
weeknumbers. The weeks are grouped to quarters evry time I update the table.

To avoid grouping and ungrouping, I am looking for a formula that gives me
the total per quarter per country starting in cell B19.

Thanking you in advance for your kind help.
Eucalypta