Just a quick tip as i couldn’t quickly find the answer in google.
If you have two cells of data and you want to add them when one might have text instead of a number, use the SUM function.
For instance
| Class | Section 1 QTY |
Section 2 QTY |
Totals |
|---|---|---|---|
| Robots | 10,000 | 1,000 | =sum(B2:C2) =11,000 |
| Humans | 9,000,000,000 | n/a | =sum(B3:C3) =9,000,000,000 |
| Plants | n/a | n/a | =sum(B4:C4) =0 |
I also searched for: sum two values if isnumeric, excel add two numbers if text only include the non text and excel add two numbers if text.