alternative to database functions

[Alex]

I have a table that looks something like this:

Customer Inv# Inv Date Amount
AAA 111 Dec 03 xx
AAA 222 Jan 04 xx
AAA 555 Feb 04 xx
DDD 112 Dec 03 yy
DDD 559 Feb 04 yy

From this I need to return a table that summarizes total
by customer, but only for, say, year 2004, or month Feb
04. I can do this using DSUM, but my problem is that the
table includes a few thousand customers, making the DSUM
function not so attractive.

Can anyone suggest an alternative?

Thanks in advance,

 

[Andy B]

Hi

Have a look at Data / Pivot Table. This is usually the best way to summarise
data. Have a look here for an intro:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Peo Sjoblom]

How about a pivot table?

http://www.cpearson.com/excel/pivots.htm

you can also use sumproduct but I am sure it will be slower than dsum

 

[Don Guillett]

try using sumproduct
=sumproduct((a2:a2000="AAA")*(year(c2:c2000=2004)*(month(c2:c2000=4)*d2:d200
0)

 

[Frank Kabel]

Hi
have a look at pivot tables:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Guest]

Thanks Don, your formula got the result I needed!

Thanks to everyone for the help!

 

[Don Guillett]

glad to help.