how to sum up values in the date criteria
 

Hello,everyone. Please help me with this problem. I have this worksheet:


PROVINCE
A B C D
E F Ak An Ca
1 Date Personnel Particulars Amount Code Province
2 01/02 Ian Travel 542 1 Ak
542
3 02/01 Mark Tires 150 3 An
150
4 02/03 May Bags 15 2 Ak
15
5 03/05 Loiue Travel 250 1 Ca
250


So I may arrive at this next sheet:

Code As of FEb. This month of Mar. As of Mar.

1 542 250
542
2 15
3 150

The formula goes on the AS OF FEB. and THIS MONTH OF MAR.
Thank you very much if you can help me...
nijins

how to sum up values in the date criteria
 

Please tell us what is the range with the dates and what is the range with
the numbers to add.
You will need something like
=SUMPROUDUCT(--(MONTH(A1:A100)=2),D1:100)
to add values in D when the date in A is for February
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"nijins" wrote in message
...
Hello,everyone. Please help me with this problem. I have this worksheet:


PROVINCE
A B C D
E F Ak An Ca
1 Date Personnel Particulars Amount Code Province
2 01/02 Ian Travel 542 1 Ak
542
3 02/01 Mark Tires 150 3 An
150
4 02/03 May Bags 15 2 Ak
15
5 03/05 Loiue Travel 250 1 Ca
250


So I may arrive at this next sheet:

Code As of FEb. This month of Mar. As of Mar.

1 542 250
542
2 15
3 150

The formula goes on the AS OF FEB. and THIS MONTH OF MAR.
Thank you very much if you can help me...
nijins