D
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.
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
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.
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