trying to sum up cells with £ and . point

hi all,

trying to sum up a selection of cells by doing this


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


how would i do this please



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