Countif on non adjacent rows
 

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?

Countif on non adjacent rows
 

Thanks it worked after I removed the sheet name for D1. I still am not sure
how offset works, but I think I'm going to need it for my next problem. Now,
I have to count the number of "D"s in one row which have a "1" two rows above
it. (The "D"s and :1"s will change later, so I'll use a reference cell.)
Then I'll need to copy the formula down the column again checking the same
pattern of every fifth row. I'm thinking I'll need to use a lookup or index
and the offset, but I'm stumped how. I'd appreciate your help again.

Thanks,
St@cy

"Tom Ogilvy" wrote:

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?

Countif on non adjacent rows
 

Okay, someone helped figure out the basic formula I needed,
=SUMPRODUCT(--('QA Input'!$E$9:$IV$9=$C$1),--('QA Input'!$E$11:$IV$11="D"))
but I still need help with the OFFSET (same conditions as before).

"St@cy" wrote:

Thanks it worked after I removed the sheet name for D1. I still am not sure
how offset works, but I think I'm going to need it for my next problem. Now,
I have to count the number of "D"s in one row which have a "1" two rows above
it. (The "D"s and :1"s will change later, so I'll use a reference cell.)
Then I'll need to copy the formula down the column again checking the same
pattern of every fifth row. I'm thinking I'll need to use a lookup or index
and the offset, but I'm stumped how. I'd appreciate your help again.

Thanks,
St@cy

"Tom Ogilvy" wrote:

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?