Forum Discussion

Kevin McNemar's avatar
Kevin McNemar
Copper Contributor
Jun 10, 2018

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 greatly appreciated. Excel"

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jun 10, 2018

    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