Adding cells that have varying contents

[Pierre]

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

 

[JE McGimpsey]

One way:

=SUM(T17:AA17)

SUM() ignores text.In article

 

[Guest]

maybe =sumif(A1:h25,"<>""",a1:h25)

 

[Pierre]

maybe =sumif(A1:h25,"<>""",a1:h25)
--
JNW









- Show quoted text -

I should have been more specific: The range containing the formulas
are in a row, but the formulas I want totaled are in "every other
column";

=SUM(T17:AA17) ,a SUM with a contiguous range won't total the cells as
needed. Couldn't get the SUMIF as noted above to work either.



T17+V17+X17 etc. Those cells contain the formula, and we're after a
total of those in column Y.

Thanks again for a second look.

Pierre

 

[Guest]

=SUMPRODUCT(--(MOD(COLUMN(T17:AA17),2)=0),T17:AA17)

 

[Pierre]

=SUMPRODUCT(--(MOD(COLUMN(T17:AA17),2)=0),T17:AA17)

Thank you Teethless!!

Pierre