Ask Your Question

Countif multiple range selection

asked 2013-07-04 06:43:43 +0100

Lionthinker gravatar image

I have a Column of numbers spread from 0 -100. I would like to count the number in a category such as the total number of 50-59, 60-69 etc.

How do I use multiple range selection for countif?

edit retag flag offensive close merge delete


Having same issue. Here's the video: and here's the spreadsheet:

ddaniels gravatar imageddaniels ( 2013-08-11 14:20:02 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-08-07 19:29:52 +0100

erAck gravatar image

Sounds like the FREQUENCY function would be your friend, entered as matrix/array function (close with Shift+Ctrl+Enter instead of just Enter).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2013-07-04 06:43:43 +0100

Seen: 808 times

Last updated: Aug 07 '15