Something along the lines of:

=COUNTIF(Offset('QA Input'!$E$9,(row(A1)-1)*5,0,1,252),'Monthly
Report'!$D$1)

Drag fill down the column.
--
Regards,
Tom Ogilvy


"St@cy" wrote in message
...
=COUNTIF('QA Input'!$E9:$IV9,'Monthly Report'!$D$1)

The formula above returns the correct information, but I need to copy it
down the column with the row changed to multiples of 5. (In other words, I
need the result of every fifth row.)

Does someone know a short cut or the programming for a macro?