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 |
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) |