Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Ignoring text when calculating cells that can contain numbers or text

Topic Labels: Formulas
124 2
Showing results for 
Search instead for 
Did you mean: 

Hi Community - I have a formula that performs a simple calculation by summing a series of cells.

The challenge comes in that some of these cells contains text, rather than numbers. I would like the formula to ignore the text so that a total can be calculated.

Currently, a ‘NaN’ is being returned. I attach an image of the cells that I am trying to calculate and the simple formula is:


Thanks in advance

2 Replies 2

Put VALUE() around each field name like this:


Depending on your text, it might not always work, but it should hopefully work most of the time.

works perfectly. thank you!