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.
Any thoughts?
Hi Preston,
First of all I suggest you read Mynda's blog on absolute references within structured tables.
Excel table absolute structured references
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.
Riny
That was very helpful, Riny. I really appreciate you taking the time to answer that.
