price for profit
If you click and select cell N5 , this is the cell that auto calculates all of the cells for the year for the Energy Bucket .
To find the formula look in the upper left hand area in the field next to the fx text. You’ll see =SUM(B5:M5) .
This is the formula that is already in the worksheet because you are using this template. If for some reason you accidentally delete the formula from a cell that you need, you can copy and paste the formula that uses the same math. Test Your Skills! If you are feeling adventurous, let’s try that. With cell N5 selected, go to the formula area and cursor over the formula to select =SUM(B5:M5) and click your delete key.
Now, select cell N4 . Copy the formula by choosing Command C for a Mac or Control C on a PC.
Jump down one cell and select the empty N5 again. To paste the formula into the cell choose Command V on a Mac or Control V on a PC.
Bam! Back to normal!
Enter your Impressions Totals for each Month You can pull this data from your sources, or if you use my Production Log Dashboard system, you’ll find the information on that spreadsheet. Click here to download the Production Log and also the companion Production Log Dashboard . These are from my eBook “Shop Basic Info Pack”.
15
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs