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:
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!!