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
Bookmarks