That's a great explanation. Thank you.
I had originally been doing it with a (SUMIF([columns with dates less than Week Ending date],INDEX([Source Data],MATCH[Name Column to Name Source Column]),1):INDEX([Source Data],MATCH([Name Column to Name Source Column]),MATCH([Date Value to Date Source Row)]). ('PIVOT EXP' is my source tab and 'TRACKER' is the calculation tab.)
Essentially, by row it is summing the total value in columns with dates up to and equal to the max date and subtracting out the sum total of values in columns with dates less than the min.
However, it wasn't working if someone listed a dollar value in the future. It would just show as error (if I removed the IFERROR). I'm not sure why though. (A workaround was to manually add $0 values with matching Week Ending dates for the weeks between the future dollar value and the current date--but that's unsustainable/unscalable.)
Anyhow, I really appreciate your insights. Thanks!!
Bookmarks