Excel Formula to Spread Income or Costs Over Months|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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