hi all,
trying to sum up a selection of cells by doing this
=sum(c4:c29)
some cells inbetween the cells are blank but i see no problem with that as it will just ignore them but all the cells contain are in currency with decimal points ie
£895.00
how would i do this please
thanks,
rob
The text £895.00 is not a number. £895.00 might be a text with 7 characters while the numeric value is only in your mind.
=COUNT(C4:C29) counts the numbers in C4:C29.
You imported those values from a text file or from clipboard, didn’t you?
Welcome @robertkwild,
You will find most of the tricks for converting text values to numbers in this article - How to convert number text to numeric data
