samiam41
asked on
Calculate column of sales and expenses
Hi experts! Attached is a spreadsheet that I need some expert assistance with as I can't figure out an easier way to calculate two columns.
For the horizontal bar at the bottom, the net total for sales should be the (qty x sale price) for each order. The same for the "cost" column. I started a formula that looked like this:
Sale Price
Net Total =(((d3*c3)+(d4*c4))-((e3*c 3)+(sum(f3 :i3)+sum(f 4:i4))
Since some of the spreadsheets have 50-100 orders, the net total for "sales" and "costs" would be incredibly time sensitive to go back and fix previous months (Oct-Feb). Is there any other way to calculate this besides one manual entry at a time? I hope so. Thanks experts!!
EE-Question.xlsx
For the horizontal bar at the bottom, the net total for sales should be the (qty x sale price) for each order. The same for the "cost" column. I started a formula that looked like this:
Sale Price
Net Total =(((d3*c3)+(d4*c4))-((e3*c
Since some of the spreadsheets have 50-100 orders, the net total for "sales" and "costs" would be incredibly time sensitive to go back and fix previous months (Oct-Feb). Is there any other way to calculate this besides one manual entry at a time? I hope so. Thanks experts!!
EE-Question.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great suggestion and will be the solution I implement. Thanks ThinkSpaceSolutions!
When I print, will the hidden columns stay hidden?Sure will.
Great suggestion and will be the solution I implement.Glad it worked out! Helper columns are sometimes the easiest to understand, implement and edit, so it has more value than a script that just does everything for you.
ASKER