Solved Subtracting from one cell, and balancing into another

December 4, 2013 at 11:58:35
Specs: Windows 7
I want to have a cell that has a number in it, and then have several cells that will have variable numbers in them, that would get subtracted from that one cell and put the balance in a different cell

message edited by scooter99


See More: Subtracting from one cell, and balancing into another

Report •

#1
December 4, 2013 at 12:55:47
✔ Best Answer
Something like:

I want to have a cell that has a number in it

Cell A1

then have several cells that will have variable numbers in them

Cell B1, C1, D1

that would get subtracted from that one cell and put the balance in a different cell

In Cell E1 the formula would be: =A1-SUM(B1:D1)

How does that work for you?

MIKE

http://www.skeptic.com/


Report •

#2
December 4, 2013 at 13:28:29
YES! WOOT! Thank you. I had it summed before the first cell, not after. Thanks for the help!

Report •
Related Solutions


Ask Question