Countif (Sumproduct) help please

  • Thread starter Thread starter Candee
  • Start date Start date
C

Candee

Hello all

I have a database spreadsheet where column A contains week numbers, &
column B contains reject codes.

I need to count the number of times that reject code "3" orrurs between
weeks 5 and 8. I've tried the sumproduct that others have suggested in
this forum, but I just can't get it to work.

Any help or insight would be greatly appreciated.

Thanks...
 
Candee,

Something like

=SUMPRODUCT((A1:A1000>=5)*(A1:A1000<=8)*(B1:B1000=3))

should work.

Dan E
 
Back
Top