sum of cells

[Khalil handal]

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!!)

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[Khalil handal]

Thanks. It worked fine.

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

--
---
HTH

Bob


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