Subtract Range Of Numbers using a Formula

G

Guest

Hello,

I was wanting to take a standard currency form cell containing the following
number: "$180.00" in cell "F4" and be able to subtract that from the nubers
formatted in the currency form in cells "F5:F10" so that the difference in
these numbers is displayed in cell "F12". If you do not understand this let
me put this in a mathmatical sense. I want to take the $180.00, subtract
32.09-16.27-16.27-19.48-15.35-44.69. those ammount are cells "F5:F10" I would
like the difference of those totals displayed in cell "F12" as previously
stated. So can anyone help me? your help would be greatly appreciated.

Thanks In Advance,

Josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting 3
Sum column of cells that already contain a formula 2
IF Question 2
subtract 4
Error when using Sum command 3
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
subtract one cell from each cell in a range and count instances 2
subtract a single cell from range of cells and then count 8

Top