Dec 26 2021 03:33 AM
for some reason, that =SUM(B4:B34) continues to equal 0 even when data is filled into the fields.. any fix for this?
Dec 26 2021 03:47 AM
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.