That is because the MOD value of MOD(n,5) is 0,1,2,3,4, there is no 5

Try

=SUMPRODUCT(--(MOD(COLUMN(53:53),5)=0),53:53)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pierian Spring" wrote in message
...
Hello, I'm using =SUMPRODUCT(--(MOD(COLUMN(53:53),5)=3),53:53) and
=SUMPRODUCT(--(MOD(COLUMN(53:53),5)=4),53:53) and they work fine. When I
go
to =SUMPRODUCT(--(MOD(COLUMN(53:53),5)=5),53:53) and
=SUMPRODUCT(--(MOD(COLUMN(53:53),5)=6),53:53) these formulae return zero.
They shouldn't because I'm just working across the columns and there are
numeric values in Columns 5 and 6. I'm a novice Excel user. Thanks in
advance! Pierian Spring