Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
Criteria for DCOUNTA for date values | Excel Discussion (Misc queries) | |||
one criteria/mult. values | Excel Worksheet Functions | |||
Frequency of values with Criteria | Excel Worksheet Functions | |||
Sum range of values that meet date criteria | Excel Discussion (Misc queries) |