One way:

=SUM(T17:AA17)

SUM() ignores text.In article
. com,
Pierre wrote:

Have a group of cells in a row that all contain similar formulas.
They look like:
=IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17))

I want to add up the results of their formulas, including the cells
that have returned blanks.

If 8 columns have this (or similar) formula, and only 2 display
numbers, how can I return a true sum, that is not" #VALUE" as a total
for that row?

TIA for any help.

Pierre