Hi

=SUMPRODUCT(--(C2:C160=2),--(J2:J160=1),--(J2:J160<=7))

Arvi Laanemets


wrote in message
ups.com...
I'm trying to count records if in col c(c2:c160) the value is =2 and in
col j(j2:j160) the value is between 1-7.

If the criteria matches count that as one record.

Any help would be much appreciated