01-25-2007, 06:11 PM
|
|
Registered User
|
|
Join Date: 25 Jan 2007
Posts: 4
|
|
Quote:
|
Originally Posted by daddylonglegs
Not sure about your example.....
=J5+O5+T5+Z5+...+IO5
wouldn't it be Y5.....and IP5
....but you could do it similar to Chip's way but with SUMPRODUCT, thus avoiding CSE.....i.e.
=SUMPRODUCT(--(MOD(COLUMN(J5:IV5)-COLUMN(J5),5)=0),J5:IV5)
|
I have given both a go and I either get 0 or 224, not sure what I am doing wrong. the cells I want to add are defintely J5, O5, T5 and so on, so maybe it is not going up in 5
|