I'm very new to excel so hopefully there's an easy fix for this. Adding and subtracting in Excel is easy you just have to create a simple formula to do it. I've tried =sum and =sumif and =countif with '>0' but that seems to return an error code. In this tutorial, I showed you how to subtract percentages in Excel. And because they are numbers, you can add and subtract times just as any other numerical values. And in case you’re using dynamic arrays, you can use the formula below: C2:C6-B2:B6. I would like negative figures to be shown but not to be added in the calculation. Once you have the formula in cell D2, you need to apply it for the entire column by copying the formula to the remaining cells. This happens as it's telling me I have too much stock and I need to order a negative amount Ie =b4+h4+j4+l4-k4-q4-n4 this works fine for me unless one of the rows has a negative figure in which causes the calculation to go array. I am trying make a formula to add 4 separate rows and subtract 3 other rows from this total. This should leave me with the total I need to order in for my next order 2 days later

Additional functions for use in Excel include subtract, multiply, divide. In the Format Cells box, click Custom in the. In cell D2, subtract the end time from the start time by entering the formula C2-B2, and then press Enter. Type the other start and end times for your friends, Joy and Leslie. I'm making a spreadsheet for ordering stock for a shop which arrives 2 days after being ordered, Basically I need to add the amount of stock I need over a 3 day period from the sales preditions i have and subtract from that total the amount of stock I have ordered to cover the predicted sales. Excel contains a large number of boxes called cells that are ordered in rows. In cell C2, enter the end time, including a or p as appropriate, and then press Enter. Hopefully I can explain this in an understandable fashion!

Excel formula to add and subtract cells