how to sum up values in the date criteria

  • Thread starter Thread starter nijins
  • Start date Start date
N

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
 
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
 
Back
Top