NO pivot table

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

 

[Gary''s Student]

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.

 

[ryguy7272]

Take a look at these:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=358
http://office.microsoft.com/en-us/excel/HA011097981033.aspx

HTH,
Ryan---

 

[Bernd P]

Hello,

I suggest to use one of my UDF's shown at:
http://sulprobil.com/html/listfreq.html

Regards,
Bernd