| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell reference for year in formula
The following formula works fine, but I want the year for the date within the
quotes to come from a cell reference. Does anyone know how I need to alter the formula to make this happen? I've tried to replace the 09 with a cell reference but have had no luck. =SUMIFS('Check Register'!H2:H1000,'Check Register'!B2:B1000,"3/31/09",'Check Register'!B2:B1000,"<4/15/09",'Check Register'!D2:D1000,A43) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
| need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
| formula to change color of a cell when date is over a year old? | New Users to Excel | |||
| Error in formula =YEAR(B4)-YEAR(A4) gives me #Value | Excel Programming | |||
| Error in formula =YEAR(B4)-YEAR(A4) gives me #Value | Excel Programming | |||
Threaded Mode
