Thank you!
"Jason Morin" wrote:
One way:
=SUMPRODUCT(--(range1="internal"),--(range2=6),--
(range2<=10))
HTH
Jason
Atlanta, GA
-----Original Message-----
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.
.
|