| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annual Timesheet: Two date ranges lookup in a single sum column
Tom,
Thanks a lot !! It worked just fine.... Regards, King Tom Ogilvy wrote: =sumif(Sheet1!A:A,"="&A2,Sheet1!C:C) - Sumif(Sheet1!A:A,""&B2,Sheet1!C:C) in C2 then drag fill down column C of Sheet2 -- Regards, Tom Ogilvy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting ranges of various column lengths, lookup values in columns | Excel Worksheet Functions | |||
| Financial rear date ranges in a single cell | Excel Discussion (Misc queries) | |||
| Matching two column ranges with a date | Excel Worksheet Functions | |||
| date in column.. need to put in a single row | Excel Discussion (Misc queries) | |||
| TIMESHEET LOOKUP | Excel Discussion (Misc queries) | |||
Threaded Mode
