Excel equation formatting

Occasional Visitor

Excel Equation.pngfor some reason, that =SUM(B4:B34) continues to equal 0 even when data is filled into the fields.. any fix for this?

1 Reply


The values in B4:B34 are probably text values.

Select the range.

Make sure that the number format is NOT set to Text.

Press Ctrl+H to activate the Replace dialog.

Enter $ in the 'Find what' box and leave the 'Replace with' box empty.

Click 'Replace All'.

If that does not solve the problem, activate the Data tab of the ribbon.

Click 'Text to Columns', then click Finish without changing any settings.