Try this

=COUNTIF(OFFSET($A$1,(INT((ROW()-1)/4)*100),0,100,1),MOD(ROW(),4)+(MOD(ROW()
,4)=0)*4)

--
HTH

Bob Phillips

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

"vandynd" wrote in message
...
I am attempting to do a COUNTIF on a long series of values. I need to
count
among the first 100 values for all of the 1, 2, 3, 4. Then count among the
next 100 (101-200) for 1,2,3,4. (repeat 25 times) I am having to go into
each
formula and type in the range of cells. Is there a faster way to do this
without naming each range before I create the formulas? Given that the
pattern repeats, it should be easy. . . I want to spend as little time as
possible scrolling up and down. Thank you!