Query

[D@annyBoy]

looking for tips on how to accomplish the following


I have 10 customers who buy goods from me every month

In worksheet A, I input dates and sales value.

customer a

date sales
01/jan/04 500.00
15/jan/04 200.00

4/feb/04 300.00
28/feb/04 450.00


in worksheet B I want to use functions to query sales from each customer for
each month

for example;


jan feb etc
customer a 700 750

I am trying to figure out how to extract the sales from worksheet A and
display the total monthly sales in worksheet B.

 

[D@annyBoy]

SUMIF(range,criteria,sum_range)

How do I set the criteria to months

date input is d/m/y

can I use >1/1/04 but <31/1/04

followed by >1/2/04 but <29/2/04

 

[Don Guillett]

try
=sumproduct((month(a2:a200)=1)*b2:b200)