|
|
#2
01-02-2025, 07:36 PM
|
||||
|
||||
It's not apparent from your workbook where the date ranges on your various tabs are supposed to come from. One can guess that they're in column C for the CDs & IRAs tabs, but there's nothing equivalent on the Savings-Checking-Money Market tab or the Annuity tab.
Assuming column C is to be used for the CDs & IRAs tabs, a workable formula for those in B2 of Total EOM worksheet might be: Code:
=SUMPRODUCT((CDs!$C$1:$C$12>DATE(B$1,ROW()-1,0))*(CDs!$C$1:$C$12<=DATE(B$1,ROW(),0)),CDs!$E$1:$E$12)+SUMPRODUCT((IRAs!$C$1:$C$12>DATE(B$1,ROW()-1,0))*(IRAs!$C$1:$C$12<=DATE(B$1,ROW(),0)),IRAs!$E$1:$E$12)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 YTD sum based on selection of month - financial year April to March
|
Parle | Excel | 3 | 03-06-2024 12:56 AM |
|
Formula to find Month and Day but excluding the year in a date
|
Marcia | Excel | 5 | 08-27-2022 06:23 AM |
|
Word field last month not working within year change
|
eduzs | Word VBA | 4 | 07-25-2019 04:31 PM |
|
Empty date cell shows wrong month & year
|
Learner7 | Excel | 3 | 06-16-2019 11:09 AM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
Windows 10 
Office 2016
Threaded Mode