Hi,
I am having trouble using the CountIf function when the range I reference contains lables that begin with <= and >=.
I recieve a large amount of data that has a column called "age range". The lowest range is <=29 and the highest range is >= 70. I do not have the underlying age that corresponds to the age range (some HR bull that doesn't allow me to know the age of employees, just their range).
When I use the CountIf and SumIf functions and try to summarize the data based on the age ranges, I get 0 for both <=29 and >=70. Is there a way to make the formula work? I've looked through the previous posts and didn't find anything helpful.
Thanks,
Mike
“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein
I am having trouble using the CountIf function when the range I reference contains lables that begin with <= and >=.
I recieve a large amount of data that has a column called "age range". The lowest range is <=29 and the highest range is >= 70. I do not have the underlying age that corresponds to the age range (some HR bull that doesn't allow me to know the age of employees, just their range).
When I use the CountIf and SumIf functions and try to summarize the data based on the age ranges, I get 0 for both <=29 and >=70. Is there a way to make the formula work? I've looked through the previous posts and didn't find anything helpful.
Thanks,
Mike
“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein