Thread: Sumif Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
canuck_heat canuck_heat is offline
external usenet poster
 
Posts: 1
Default 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