If there are blank cells in the data area of LINEST, how can I SKIP them but still get a result？

[Natalie12138]

I am using "=@INDEX(LINEST(E$12:E$16,$C$12:$C$16,,TRUE),,2)" now , but I find if I delete a few data , it would turn out to be #VALUE; I want to know how can I get the results without deleting the whole row? Should I add the IF functions?

 

[Natalie12138]

YES! This is EXACTLY what I want !!! I appreciate your help!!! You wonderfully helped me with my first excel question on MREXCEL and in my first internship!!!! Canada, GREAT country!! Canadian, GREAT people!!

Thanks again!!!!!

 

[Domenic]

That's great, I'm glad I was able to help. And thanks for your feedback.

By the way, there are also great people here who are from around the world and who are happy to help.

Cheers!