Forum Discussion
Formula error
I can't figure out how to fix my error!
It would help if you included the whole formula. Also, what is "PossiblePtsMid" ? Is that a valid named range or values? If you click in the cell and highlight that name and then hover over that highlight does it show values or #NAME? and/or highlight the whole SUM(PossiblePtsMid) and does it show the correct sum you were expecting or #NAME?
If that isn't the issue and there isn't something after the "Warning!" (i.e. in the false conditional output) then is is possible the version/location your are using is expecting semi-colon instead of commas?