View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default SumIf with date range

I have a formula:

=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2)

AE1:BQ1 on the Details page are dates
CurDate is the current date and is a named cell
AE2:BQ2 on the Details page are values

I need the formula to look at the date range AE1:BQ1 and determine if it's
value is greater than or equal to the value of the CurDate. If it is then
sum the fields in AE2:BQ2.

The formula I have presented above does not work.....any suggestions?