Cell 1 = Number
Cell 2 = Number
Cell 3 = "#N/A"
Cell 4 = sum(cell1:cell3)
My 'sum' result in Cell 4 = #N/A
I want Cell 4 to = Cell 1 + Cell 2
I am trying to sum just the numbers and avoid the #N/A character in my summation....how can I do this.
Please help
Cell 2 = Number
Cell 3 = "#N/A"
Cell 4 = sum(cell1:cell3)
My 'sum' result in Cell 4 = #N/A
I want Cell 4 to = Cell 1 + Cell 2
I am trying to sum just the numbers and avoid the #N/A character in my summation....how can I do this.
Please help