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