Google Spreadsheet Post #2010
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!
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-08-2016
post by: R SIC:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/AS4HB1gJlo8;context-place=forum/docsneed 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!
(hope the link worked)
-------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment