Number formula problem

I have a spreadsheet that in it I am trying to add a row of numbers. However, some of the cells in the row contain errors because they are 'future' looking column and have formulas in them that are not yet populated. Anyway, I want the sum formula to ignore those cells or at least treat the 'error' as a zero, then sum up the row. Have tried this formula, but it just makes the total sum to be '0'.

Help!

IFERROR(SUM(C52:AR52),0)

MacBook Air 11″, macOS 10.15

Posted on Jan 19, 2023 9:27 AM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Number formula problem

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.