Sumproduct as a Pivot table

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?
 
T

Tim Zych

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Incone & Expenses Statement 0
Pivot Table Data Aggregation 0
Pivot table grouping help 0
Sumproduct Help! 3

Top