Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif withdates
I am trying to check a column of dates and if that column corresponds with
the critera (in other words if the dates match), I want it to add the invoice values together. I can't get it to work, it returns the result zero all the time? Can anybody help. What am I doing wrong? E.G. I want excel to check the dates under the payment due column (RANGE) and if any date matches the date under the criteria column i then want it to add the invoice values together. Working example is, check payment dues dates and if any match criteria 01/06/2007 then add the values together, so there are 2 instances of date 01/06/2007 so excel should add the corresponding values together i.e.15.25+845.00 payment due invoice value RANGE SUM VALUE 01/06/2007 15.25 01/07/2007 26.00 01/08/2007 56.00 01/06/2007 845.00 01/07/2007 2256.33 01/08/2007 45.23 CRITERIA Jun Jul Aug 01/06/2007 0.00 0.00 0.00 01/07/2007 01/08/2007 Trying to sum payments due jun here Trying to sum payments due jul here Trying to sum payments due aug here Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif withdates
=SUMIF(A:A,I2,B:B)
where criteria is in column I -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Treg" wrote in message ... I am trying to check a column of dates and if that column corresponds with the critera (in other words if the dates match), I want it to add the invoice values together. I can't get it to work, it returns the result zero all the time? Can anybody help. What am I doing wrong? E.G. I want excel to check the dates under the payment due column (RANGE) and if any date matches the date under the criteria column i then want it to add the invoice values together. Working example is, check payment dues dates and if any match criteria 01/06/2007 then add the values together, so there are 2 instances of date 01/06/2007 so excel should add the corresponding values together i.e.15.25+845.00 payment due invoice value RANGE SUM VALUE 01/06/2007 15.25 01/07/2007 26.00 01/08/2007 56.00 01/06/2007 845.00 01/07/2007 2256.33 01/08/2007 45.23 CRITERIA Jun Jul Aug 01/06/2007 0.00 0.00 0.00 01/07/2007 01/08/2007 Trying to sum payments due jun here Trying to sum payments due jul here Trying to sum payments due aug here Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif withdates
Assume source data within D2:E7, dates in col D, amts in col E
Assume you have 1st-of-month real dates (formatted as say: mmm-yy) in D10:F10 as headers, viz: Jun-07, Jul-07, Aug-07 Then you could place in D11: =SUMIF($D$2:$D$7,D$10,$E$2:$E$7) and copy across to F11 to return the required sums below each month header -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Treg" wrote: I am trying to check a column of dates and if that column corresponds with the critera (in other words if the dates match), I want it to add the invoice values together. I can't get it to work, it returns the result zero all the time? Can anybody help. What am I doing wrong? E.G. I want excel to check the dates under the payment due column (RANGE) and if any date matches the date under the criteria column i then want it to add the invoice values together. Working example is, check payment dues dates and if any match criteria 01/06/2007 then add the values together, so there are 2 instances of date 01/06/2007 so excel should add the corresponding values together i.e.15.25+845.00 payment due invoice value RANGE SUM VALUE 01/06/2007 15.25 01/07/2007 26.00 01/08/2007 56.00 01/06/2007 845.00 01/07/2007 2256.33 01/08/2007 45.23 CRITERIA Jun Jul Aug 01/06/2007 0.00 0.00 0.00 01/07/2007 01/08/2007 Trying to sum payments due jun here Trying to sum payments due jul here Trying to sum payments due aug here Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
help with SUMIF | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |