alternative to database functions

  • Thread starter Thread starter Alex
  • Start date Start date
A

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,
 
try using sumproduct
=sumproduct((a2:a2000="AAA")*(year(c2:c2000=2004)*(month(c2:c2000=4)*d2:d200
0)
 
Back
Top