how to sum up values in the date criteria

[nijins]

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

 

[Bernard Liengme]

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