sum of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil handal - 23 Jan 2008 09:47 GMT

Hi,
In Cell AB10 I need a formula to sum the following cells inthe same line.
The cells are:
D, F, H, J, L, N, P, R, T, V, X, Z
Is there a way to do this other than using: =d10+f10+h10........+z10
(sum of every other cell!!)

Reply to this Message

Bob Phillips - 23 Jan 2008 10:48 GMT

=SUMPRODUCT(--(MOD(COLUMN(D2:Z2),2)=0),D2:Z2)

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
> In Cell AB10 I need a formula to sum the following cells inthe same line.
> The cells are:
> D, F, H, J, L, N, P, R, T, V, X, Z
> Is there a way to do this other than using: =d10+f10+h10........+z10
> (sum of every other cell!!)

Reply to this Message

Khalil handal - 24 Jan 2008 07:40 GMT

Thanks. It worked fine.

> =SUMPRODUCT(--(MOD(COLUMN(D2:Z2),2)=0),D2:Z2)
>
[quoted text clipped - 4 lines]
>> Is there a way to do this other than using: =d10+f10+h10........+z10
>> (sum of every other cell!!)

Reply to this Message