Thread: count if
View Single Post
  #5   Report Post  
bj
 
Posts: n/a
Default

It depends on how many cells you want to count, If is less than 30 use
=count(a1,a3,a5,c4,t8,...)
if it is more than 30
select the cells using th control key
go to <insert<Name<define and give a unique name to the group (for
example "rover"
then use
=count(rover)
I do not know how many cells can be named in a group, you may have to use
several names of groups to get up to your total requirements
=count(rover,spot,reX)

"Help with count if" wrote:

I need to count cells -than content text not numbers- with a defined
condition but the cells are not follow (not a range or cells). What
function/s can I use?