need help with a pricing sheet
Hello all, I've been reading up on a lot of posts on here and have learned quite a bit. I was wondering if there was an easier way for me to accomplish something. I work at a bar, and have several reps that I order from. I created sheets for my orders so I can track my spending. I have prices in column B, and quantity in column C, and a total price in cell C12. I was wondering if there was an easier way to calculate the pricing, rather than add (C3*B3)+(C4*B4) etc. Something similar to the C12:G12 formula, but with the addition of multiplying the price? This sheet is rather short, but some of mine are upwards of 50 products, and I am constantly adding more products each month. I appreciate any help!