"Ken" wrote in message
...
Thank you for the reply. I cut and pasted you suggestion into my sheet and
modified the array range to fit my requirements (S14:GV14). however, the
result was a value# error. I will see if I can trace the error.

ken

If you have a Row range such as A10:A45:
=SUMPRODUCT(--(NOT(MOD(ROW(Range),3))),(Range))

If you have a Column range such as A10:K10:
=SUMPRODUCT(--(NOT(MOD(COLUMN(Range),3))),(Range))

Bruno