Excel 2007 formula error

S

Spanky deMonkey

I have used this before and am wondering why it isn't working now.

I have numbers in Cells B1 thru B4

I want to take the amount in B1 and Subtract B2 thru B4.

In cell B5, I entered =SUM(B1 - B2:B4)

I received an error: !VALUE#

When I click on the Row B, the value is "General", and I had it as a
"Number" but still got the same error.

What gives?

Thanks for any help.
 
G

Gord Dibben

I don't know how it possibly worked before but this is how it will work.

=B1-SUM(B2:B4)


Gord Dibben MS Excel MVP
 

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

Count cells containing text, multiple criteria 2
How to do this with macro? 2
Need macro that analyses 2 columns . Delets row if same text is fo 3
Comparing Formula Strings after Row has been Inserted 3
Single Row to Multiple Row Determination 1
Macro that splits content from cell if given character is found 4
Need Help with a Formula 4
array error 5

Top