Excel: Formula to find last non blank cell value in a range

I need help finding the value of the last non blank cell in the range (CO40:DB40). These cells do have formulas in them. Some cells may have zero (0) values. If cells (CO40:DB40) are all blank, than I'd like the answer to be zero (0). Thanks!

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of August 06, 2014.

For more resources for Microsoft Excel