Hi Mike,
oh, sorry, it was my mistake. it works.
how about to calculate base on each week, week 1, week 2......
thanks & regards,
Lowan

--
Lowan


"Mike H" wrote:

Hi,

=SUMPRODUCT((A1:A10=DATE(2009,12,1))*(A1:A10<=DAT E(2009,12,7))*(B1:B10="A")*(C1:C10))

Mike

"Lowan Chan" wrote:

Hi,

I have a table similar as below, how can I calculate the amount of A during
December 1 to 7? I know I can use DSUM for sigle result, but my purpose is
to consoladate a table for A, B, C. Is there any formula I can use?

coloum A coloum B coloum C
1/12/09 A 100
5/12/09 C 50
9/12/09 A 120
8/12/09 B 80
4/12/09 A 90

Thanks a lot!
--
Lowan