View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
irvine79 irvine79 is offline
external usenet poster
 
Posts: 21
Default MAX figure within a date range as a function of today()'s date

Column B = All dates for this year.
Column H = production figures entered daily.

My goal is to come up with a cell that calculates the max daily production
figure for the month by referencing today's date to find which month to
consider.

I am using a sumif formula to calculate the month's cumulative production
figure but haven't figured out how to find the highest daily figure of the
month.

=SUMIF(B3:B262,TEXT(TODAY(),"mmm"),H3:H262) ...

Basically in need a MAX version of the above formula.

Thanks!