View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graham Graham is offline
external usenet poster
 
Posts: 155
Default Error Message :A value used in the formula is of the wrong data ty

Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep
getting the above error message, and I cant see why ?
I have a column, with values in A6:A9, I want to add these together and then
subtract the total from a value in A10.
I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells
are formatted as General Numbers to 2 decimal places.
Can anyone help please ?