Countif using criteria in multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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
 
Back
Top