How do I correctly use Sum & Value formulas together?
I'm trying to get the total monthly parking charges for my office.
I have a column showing each individual's monthly parking charges, if applicable (enabled or disabled).
For the sheet summary, using =sum([Monthly Cost]1:[Monthly Cost]84) doesn't return anything but 0 because the column is using text.
I've tried adding the VALUE function but keep getting errors--the formula works on a single cell but not if I try dragging more than one.
Any suggestions or help?