I have database dump with info in several columns. Would like to tabulate count that meets specified criteria.
COLOR NUMBER REGION
----- ------ ------
green 5 FL
blue 6 GA
blue 4 FL
blue 1 FL
red 7 NY
What formula can I write to count numer of occurances of blue in FL having number
between 4 and 6 to produce correct result of 2?
COLOR NUMBER REGION
----- ------ ------
green 5 FL
blue 6 GA
blue 4 FL
blue 1 FL
red 7 NY
What formula can I write to count numer of occurances of blue in FL having number
between 4 and 6 to produce correct result of 2?