Adding cells that have varying contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 11 Sep 2007 21:51 GMT

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

Reply to this Message

JE McGimpsey - 11 Sep 2007 22:27 GMT

One way:

=SUM(T17:AA17)

SUM() ignores text.In article
<1189543888.977736.25390@e34g2000pro.googlegroups.com>,

> Have a group of cells in a row that all contain similar formulas.
> They look like:
[quoted text clipped - 10 lines]
>
> Pierre

Reply to this Message

JNW - 11 Sep 2007 23:14 GMT

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

Signature

JNW

> Have a group of cells in a row that all contain similar formulas.
> They look like:
[quoted text clipped - 10 lines]
>
> Pierre

Reply to this Message

Pierre - 12 Sep 2007 01:15 GMT

> maybe =sumif(A1:h25,"<>""",a1:h25)
> --
[quoted text clipped - 16 lines]
>
> - 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

Reply to this Message

Teethless mama - 12 Sep 2007 02:08 GMT

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

> > maybe =sumif(A1:h25,"<>""",a1:h25)
> > --
[quoted text clipped - 30 lines]
>
> Pierre

Reply to this Message

Pierre - 12 Sep 2007 02:57 GMT

On Sep 11, 8:08 pm, Teethless mama
<Teethlessm...@discussions.microsoft.com> wrote:

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

Thank you Teethless!!

Pierre

Reply to this Message