Why are most of my months showing up "N/A" when I know there is data?

NBKD

Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below

Populates only one month:

MichaelTCA

Hello @NBKD

You'll have to do some detective work.

Make sure the month and year are actual values and not 0. Unless you default to a month of 0 being used as a trigger or reference for another analysis.

The columns being referenced, the cells being evaluated, and May83 need to be all date columns.

I would remove all the IFERROR functions in the middle and keep the one surrounding the entire function.

If you have a Month of 0 and Year of 0, there's no reason to default to an error value that causes another error when an error has already occurred.