December 21, 2022
I'm attempting to replicate what Mynda did in this article: Excel formula to spread income or costs over months, but I'm referencing a table and getting $0 where there should be a sum, and a #VALUE error where the should be $0.
January 31, 2022
First of all I suggest you read Mynda's blog on absolute references within structured tables.
Then, be aware that a header like "Jan-23" in a structured table is a plain text, even when you initially entered them as a real date and than transformed the range to a table. So, you can't use them in functions that depend on date intelligence. That's why you get the zero's.
In the attached file, I have added a row above the table containing real "beginning of the month" dates. I used absolute table references where needed and wrapped the lot in IFERROR to turn VALUE errors into zero's.
See if you can follow. If not come back here.