NO pivot table

  • Thread starter Thread starter DavisGail
  • Start date Start date
D

DavisGail

Is there a formula that will summarize data without having to use a pivot
table?

I want it to summarize like a pivot table without using one? Perhaps a
vlookup or index, or match formula?
 
Yes.

You can usually summarize data with sets of =SUMPRODUCT() equations.

The approach requires more work than making a pivot table, but it has the
advantage that the summary will automatically refresh as the data is modified.
 
Back
Top