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

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

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