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.
--
Gary''s Student - gsnu200907


"DavisGail" wrote:

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?