Hi Domenic,

Thank you for reply. The Formula works Great!

=SUMPRODUCT(--(MOD(ROW(A1:A100)-ROW(A1)+0,3)=0),--(A1:A100=B1))

Cheers,
Sam


Domenic wrote:
Assuming that A1:A100 contains your data, to count every third row,
starting with the first cell in the range, try...

=SUMPRODUCT(--(MOD(ROW(A1:A100)-ROW(A1)+0,3)=0),--(A1:A100=B1))

...where B1 contains your criteria. To count every third row, starting
with the third cell in the range or the first occurrence of third,
change the +0 bit to +1.

Hope this helps!

Hi All,

[quoted text clipped - 6 lines]
Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1