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