Countif using criteria in multiple columns
 

Hi ~

I need to get a count of cells in column F that equal a number between
111000 and 111999, when the corresponding cell in column G equals 924350,
924550, 934350, or 934570. I've tried using the below formula for the first
part but can't figure out the second part. Help!

=COUNTIF(CLOSED!F:F,"=111000")-COUNTIF(CLOSED!F:F,"=111999")

Countif using criteria in multiple columns
 

Hi!

Try this:

A1 = 111000
B1 = 111999
C1:C4 = 924350; 924550; 934350; 934570

=SUMPRODUCT(--(Closed!F1:F10=A1),--(Closed!F1:F10<=B1),--(ISNUMBER(MATCH(Closed!G1:G10,C1:C4,0))))

Note: Sumproduct will not work on entire columns F:F

Biff

"ImaGina" wrote in message
...
Hi ~

I need to get a count of cells in column F that equal a number between
111000 and 111999, when the corresponding cell in column G equals 924350,
924550, 934350, or 934570. I've tried using the below formula for the
first
part but can't figure out the second part. Help!

=COUNTIF(CLOSED!F:F,"=111000")-COUNTIF(CLOSED!F:F,"=111999")