maybe (not tested)

=sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)=0))

"DLAYMANS" wrote:

I have a spread sheet that has a formula at the bottom to count all cells
that have the work day. This calculation =COUNTIF(B7:O170,"DAY"). This
counts all cells that have the word day. I want to exclude Lines 7, 10, 13,
16, 19 and so forth, only have the calculation for say every 3rd line. Is
there a way to exclude certain lines in my calculation.

Thanks for any help.
--
DLAYMANS