| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Date range criteria and Pivot tables (again!) | Excel Worksheet Functions | |||
| How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
Threaded Mode
