Hello Sandy from Steved

Thankyou.

"Sandy Mann" wrote:

There is no COL function in my version of XL so i assume that is why you get
the #NAME! error

Try:

=SUM((IF(MOD(ROW(C1:C29),3)=0,C1:C29)))
array entered or

=SUMPRODUCT(((MOD(ROW(C1:C29),3)=0)*(C1:C29)))
normally entered

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Steved" wrote in message
...
Hello from Steved

Below is my attempt but is returning a #NAME! Value.

=SUM(IF(MOD(COL($C$3:$C$29)-1,$C$3)=0,$C$3:$C$29,0))
Thankyou.

"Steved" wrote:

Hello from Steved

I have formulas in cell C3,C6,C9,C12,C15,C18,C21,C24 and C27

If I do this =C3+C6+C9+C12+C15+C18+C21+C24+C27
I get a #VALUE! in the cell

Please What is require for me to get an answer.

Thankyou.