Hello Forum,
I use an excel spreadsheet that is similar to a calendar format to track picking decisions:
Capture.PNG

I would like to calculate a trend of Brix decrease per day (with each block). However, I cannot overcome the innumerable blank cells in the worksheet. How can I write a formula for a trend that ignores blank cells?

Thank you for your help and advice!