Formula help; I want #NA to show so it doesn't show on graph

I am using the sumif function and referencing from another sheet. If a month has not occurred then in the actual's a "0" will appear. The point is to automatically update the sheets which then leads to graphs in the workbook. Which is why if I could have "#NA" show up if a "0" is shown then the graphs wont be skewed. I have tried several ideas with another if statement and what not and cant figure out what to do. Hopefully someone is able to help me out.

Formula being used: (is referencing correctly)

=SUM(IF('H:\[12 MO ACTUAL.XLS]033300-020'!$A$9:$A$20=$A14,INDEX('H:\[12 MO ACTUAL.XLS]033300-020'!$A$9:$N$14,,COLUMN(B3))))

Thanks,
Ant

Hello,

I'm using the sum function because last time I tried something similar it ended up working out so I stuck with it when a similar project came up. Trying to learn different ways to mix in everything. But yes, I attached an excel document containing what I am doing.

-Went ahead and moved the file over to the same workbook to make it easier (the file that I am referencing from)
-In may and june of actual's you will see where it still shows on the graph. operating income, with formula; total direct expense, with a "0", POM with #N/A (doesnt show) which is what I would like it to have so I can just pull the updated actual's into a folder at it'll update all of tabs to latest month entered.

Thanks,
Ant

Actually it works. Forgot to ctrl shift enter to set the array.

If you know another way to do this besides using the sum function, please let me know.

Thanks,
Ant

Could you please explain in more detail, compared to the file I gave you? I am using the index match function you gave me now, and it keeps returning #na.

Oh okay got it.

So when I enter the formula into cell B14 and drag it across it for the rest of the months it still returns the "#na" for all of the months.

But also the formula is different from the previous one that you gave.