Error Message :A value used in the formula is of the wrong data ty

G

Graham

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 ?
 
S

Shane Devenshire

Hi,

This is interesting but - in 2007 you get an answer with your original
formula without getting an error but in 2003 you get the #VALUE! error.

However, in both version Excel will calculate a number for your formula if
you enter it as an array (Ctrl+Shift+Enter). But in that case Excel thinks
you want to perform the following calculations
SUM(A10-A6,A10-A7,A10-A8,A10-A9)
 

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

Copy the content of a cell with Formula 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Remove specific cells in a column. 2
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
multipule calculations in a single column 2
Value used is wrong data type.. 3
in the worksheet, a1 to a10 have numbers. I want to calculate to a 2
If formula producing #VALUE Error 2

Top