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*c3)+(sum(f3:i3)+sum(f4: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
LVL 9
samiam41Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Steven HarrisConnect With a Mentor PresidentCommented:
As a quick workaround, add a helper column.

In Column K, use:

=SUM(C3*D3) and then copy down to all rows.

Then use:

Net Sale Price - =SUM(K3:K4)
Net (Profit?) in E15 - =(D14-E14)+SUM(F14:I14)
0
 
samiam41Author Commented:
ThinkSpaceSolutions, thank you for the quick solution.  I plugged it in and it I like the results.  I hide the columns from the view.  When I print, will the hidden columns stay hidden?  I can't remember if that is a setting or not (don't print hidden column).
0
 
samiam41Author Commented:
Great suggestion and will be the solution I implement.  Thanks ThinkSpaceSolutions!
0
 
Steven HarrisPresidentCommented:
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.
0
All Courses

From novice to tech pro — start learning today.