Multiply Cells that are not blank
<p>I need to multiply the QTYs in column B by the values in the other columns if they are not blank, row by row like this: ($B3*Row,Col). I know I can do this with VBA, but I can't get a method going that will multiply and check blank cells. The last row just sums up numbers in each column. I tried making a function and putting it in a sub, but I had no luck. I've attached a picture.
<a href="https://i.stack.imgur.com/M8hux.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/M8hux.png" alt="enter image description here"></a>
Thank you!</p>