A have a colum with (a lot of) numbers.
I want to count the number of cells that have a value between 250 and 500.
I presume I shall use the COUNTIF-function, but I am stuck....
Can anybody help ?
Saturn
A have a colum with (a lot of) numbers.
I want to count the number of cells that have a value between 250 and 500.
I presume I shall use the COUNTIF-function, but I am stuck....
Can anybody help ?
Saturn
Last edited by Saturn; 10-04-2011 at 11:28 AM.
Try COUNTIFS (with an "S") , e.g. for column A
=COUNTIFS(A:A,">=250",A:A,"<=500")
that includes both 250 and 500 and everything in between....
Audere est facere
Great, daddylonglegs!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks