Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Question about using SUM with a date criteria
Hello,
I'm using the following array formula (Thank you again Macropod!) to add Sick/Vacation/Personal leave hours (as simple numbers) in cells that also contain text: =SUM(IF(ISERROR(VALUE(LEFT(B1:B4,FIND(" ",B1:B4)-1))),0,VALUE(LEFT(B1:B4,FIND(" ",B1:B4)-1)))) Is there a way to add a date criteria to this formula so that it will only add those hours as of the current date? In the spreadsheet, Column A contains dates. Any help is appreciated. Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
DCOUNTA Complex Criteria Question | Excel Worksheet Functions | |||
Criteria based sum question | Excel Discussion (Misc queries) | |||
SUMIF Question Criteria | Excel Worksheet Functions | |||
query criteria question | Excel Discussion (Misc queries) |