Pivot Table formula

  • Thread starter Thread starter AndyNorgate
  • Start date Start date
A

AndyNorgate

I would like to produce a Pivot Table, but without using the Pivot table
function. I would like to use the SUMIF but I am aware that this can
only be done for a single criteria. I have used the Condition Sum
Wizard but this cannot be copies down or across without returning
#Value. How can I find the formula behind a Pivot table so I can type
his in myself.

Thanks for any assistance.

Andy
 
As a pivot table convert I cannot understand why you would want to do
things the hard way <<grin>>. Or do you mean that you want to make a
pivot table macro? - in which case the best method is to set the macro
recorder and make one up manually to see what code is produced.

Another thing you might like to look at is Data/Goup and Outline, which
does a similar job in a worksheet - providing you have sorted your data
correctly.
 
Take a look at the SUMPRODUCT function which will allow you to specify numerous
criteria.
 
Back
Top