Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Function
Can anyone help me use a greater then constraint on a specific cell as part
of my sumif function. For example the following formula works perfectly =SUMIF(G25:G29,"K25",I25:I29) but as soon as I add greater then the value of cell K25 as my constraint it always returns a value of 0 =SUMIF(G25:G29,"K25",I25:I29) I am trying to sum production data for any day that is greater then the current date. Thanks for the help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Function
Try it like this:
=SUMIF(G25:G29,""&K25,I25:I29) -- Biff Microsoft Excel MVP "canuck_heat" wrote in message ... Can anyone help me use a greater then constraint on a specific cell as part of my sumif function. For example the following formula works perfectly =SUMIF(G25:G29,"K25",I25:I29) but as soon as I add greater then the value of cell K25 as my constraint it always returns a value of 0 =SUMIF(G25:G29,"K25",I25:I29) I am trying to sum production data for any day that is greater then the current date. Thanks for the help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Function
I *don't* believe that your formula works perfectly:
=SUMIF(G25:G29,"K25",I25:I29) Where you have a date in K25, and you want to add the corresponding rows in Column I that match the date in Column G! This *would work*: =SUMIF(G25:G29,K25,I25:I29) AND, to revise it to "greater than", try: =SUMIF(G25:G29,""&K25,I25:I29) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "canuck_heat" wrote in message ... Can anyone help me use a greater then constraint on a specific cell as part of my sumif function. For example the following formula works perfectly =SUMIF(G25:G29,"K25",I25:I29) but as soon as I add greater then the value of cell K25 as my constraint it always returns a value of 0 =SUMIF(G25:G29,"K25",I25:I29) I am trying to sum production data for any day that is greater then the current date. Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |