| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing values for a range of dates
As long as the dates involved are all proper dates (not text) then: =SUMPRODUCT(--($AA$10:$BE$10<=B6),$AA$12:$BE$12) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119196 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing values based on calendar dates | Excel Discussion (Misc queries) | |||
| Summing based on a range of dates | Excel Discussion (Misc queries) | |||
| Summing non hidden values in a range | Excel Discussion (Misc queries) | |||
| Summing values b/t two dates | Excel Discussion (Misc queries) | |||
| Summing values within a range | Excel Discussion (Misc queries) | |||
Threaded Mode
