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