Tag Archives: Excel

Excel tip – adding two numbers where one is text

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
Section 2
Robots 10,000 1,000 =sum(B2:C2)
Humans 9,000,000,000 n/a =sum(B3:C3)
Plants n/a n/a =sum(B4:C4)

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.