Software

Ask something
Discussion Locked

EXCEL - AGE RANGE MATCHING

0 helpful
3 replies

by adisha

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can anyone tell me how I can use the COUNTIF (or similar function) to count the number of cells that fall within a number range (i.e. AGE RANGE) e.g. >=4 AND <=16.

Any help would be greatly appreciated.

Many thanks for your help in advance.

3 replies

by adisha

Thank you so much! This is great :-) I spent ages using logical statements - I had no idea it was this straightforward.

This discussion is closed to new replies.