View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default =SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)

Excel Yoda's,

Thanks for the help.

The following does not work:

=SUMIF(B8:B38,"<"&TODAY(),D8+H8+L8+P8+U8+Y8)

however when using as the following it works fine:

=SUMIF(B8:B38,"<"&TODAY(),D8:Y8)

What wrong I do?

Thanks