Excel 2007 formula error
 

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.

Excel 2007 formula error
 

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

On Sat, 10 Mar 2007 13:41:31 -0800, "Spanky deMonkey"
wrote:

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.