NO pivot table
 

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?

NO pivot table
 

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?

NO pivot table
 

Take a look at these:
http://pubs.logicalexpressions.com/P...cle.asp?ID=358
http://office.microsoft.com/en-us/ex...097981033.aspx

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

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?

NO pivot table
 

Hello,

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

Regards,
Bernd