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

"ImaGina" <(E-Mail Removed)> wrote in message
news:99238F12-13B3-4398-B23B-(E-Mail Removed)...
> 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")