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

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

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


"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

On Sep 11, 5:14 pm, JNW wrote:
maybe =sumif(A1:h25,"<""",a1:h25)
--
JNW



"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- Hide quoted text -

- 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

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


"Pierre" wrote:

On Sep 11, 5:14 pm, JNW wrote:
maybe =sumif(A1:h25,"<""",a1:h25)
--
JNW



"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- Hide quoted text -

- 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

On Sep 11, 8:08 pm, Teethless mama
wrote:
=SUMPRODUCT(--(MOD(COLUMN(T17:AA17),2)=0),T17:AA17)






Thank you Teethless!!

Pierre