Hello,
I'm looking to use this formula =SUMPRODUCT(LEFT(G3:G1000,2)+(RIGHT(G3:G1000,8))) with cells that have numbers in but some in the middle are blank. If I try and return it at the moment, I get a value error due to blank cells. How do I get it to skip blanks?
I don't want to shorten the column as I want to be able to insert new information everyday and the cell range to be long enough to always add up the numbers without adjusting the range.
Thanks,
Bookmarks