Sumproduct as a Pivot table

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a summary sheet with a lot of =Sumproduct
formulas.

All the formals have to meet certain criteria. Is there
a way that I can see how i generated that number?

For example ... in a Pivot table... i can double click
the number and I can the data

Is this possible?
 
One helper is to select any part of the formula in the formula bar and press
F9. Excel will evaluate the selected part. Press ESC to escape the
evaluation.
 
Back
Top