[FONT="Arial"]I am trying to trend some data and need some help or other alternatives to solve my issue. I have tried TREND with INDIRECT and get the incorrect answer. In columns M and N the highlighted cells in yellow are the correct answers.[/FONT]
[FONT="Arial"]My question is: How do I get TREND to ignore the zeros?
I posted this question here but am not getting answers: