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.