COUNTIF Function
 

I would like to look at one column (range1) in excel and if the word
"internal" appears, I would like to then look to the next column (range2) and
count the total number of times the value is between 6 and 10...

Internal 8
Internal 2
External 7

So in this data set, I would like my result to be equal to 1. Both internal
and between 6 and 10. I can do them separately but cannot figure out how to
combine the 2 formulas...

=COUNTIF(range1, "internal")
=COUNTIF(range2,"<=10")-COUNTIF(range2,"<6")

Any help is greatly appreciated.

=SUMPRODUCT((A2:A4<=10)*(A2:A4=6)*(B2:B4="Interna l"))
:)

"Meredith" wrote:

I would like to look at one column (range1) in excel and if the word
"internal" appears, I would like to then look to the next column (range2) and
count the total number of times the value is between 6 and 10...

Internal 8
Internal 2
External 7

So in this data set, I would like my result to be equal to 1. Both internal
and between 6 and 10. I can do them separately but cannot figure out how to
combine the 2 formulas...

=COUNTIF(range1, "internal")
=COUNTIF(range2,"<=10")-COUNTIF(range2,"<6")

Any help is greatly appreciated.

Thank you so much!

"Naomi" wrote:

=SUMPRODUCT((A2:A4<=10)*(A2:A4=6)*(B2:B4="Interna l"))
:)

"Meredith" wrote:

I would like to look at one column (range1) in excel and if the word
"internal" appears, I would like to then look to the next column (range2) and
count the total number of times the value is between 6 and 10...

Internal 8
Internal 2
External 7

So in this data set, I would like my result to be equal to 1. Both internal
and between 6 and 10. I can do them separately but cannot figure out how to
combine the 2 formulas...

=COUNTIF(range1, "internal")
=COUNTIF(range2,"<=10")-COUNTIF(range2,"<6")

Any help is greatly appreciated.