Formula =sum(E31:E39) returns sum of $0

Screen Shot 2022-01-13 at 2.46.58 PM

Looking at the space between the $ and the 4,800.00 - I get a feeling that these cells might be text cells which are right aligned. Could you click on one of them and see the icon that shows up in the ‘data type button’ in the toolbar? If it is not a $ , then they are likely text cells.


You can select the whole range and change their datatype using the same tool.

1 Like

These were text cells! Thanks for your help.

1 Like