Forum Discussion
Trying to "ADD" numbers
"I'm trying to "ADD" number in multiple cells, I want to leave one cell blank until I need to use it. I keep getting "value" I know i'm getting this because of the blank cell. Help with this would br...
Hi Kevin,
Try to use https://support.office.com/en-us/article/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89 instead as below example:
=SUM(A1:A10)
Where: A1:A10 is the targeted range to sum.
NOTE: The SUM function ignores any text or blanks between the range of numbers.
Regards