We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Count number of cells in a range [closed]

asked 2012-07-30 21:36:41 +0200

Gabriel gravatar image

Say I have column A with a certain number of cells, all of which have numbers. I need a way to count the number of cells in column A which fall into a given range, say [0.5,1]

I've tried COUNTIF but I don't know how to put two conditions in a single statement (ie: bigger than 0.5 and smaller than 1)

How would I go about doing this?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 15:02:45.649093

2 Answers

Sort by » oldest newest most voted

answered 2012-07-30 22:38:48 +0200

Gabriel gravatar image
edit flag offensive delete link more

answered 2012-07-30 23:58:27 +0200

m.a.riosv gravatar image
edit flag offensive delete link more

Question Tools


Asked: 2012-07-30 21:36:41 +0200

Seen: 7,778 times

Last updated: Jul 30 '12