View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spanky deMonkey[_2_] Spanky deMonkey[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.