Thread
:
function contif
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Mike
external usenet poster
Posts: 3,101
function contif
Checks the range A2 - A10 for numbers =5 and <=20.
=COUNTIF(A2:A10,"=5")-COUNTIF(A2:A10,"20")
Mike
"IsaÃ*as." wrote:
I´ve a list of numbers and want to use the count how many of this is within
the ranges
Reply With Quote
Mike
View Public Profile
Find all posts by Mike