# total list of names

#### archigirl

##### New Member
I have an attendance list for a meeting. The names are divided into three columns, Adults, Girls, and Boys. Is there a function I can use to count the total number of entries within a certain range of cells? Or, is there a function that allows you to count the number of occurences of, say, green text or red text?

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
You can use B for boys G for Girls or A for Adults then just enter the formula:

=COUNTIF(a7:a64,"A")
=COUNTIF(a7:a64,"B")
=COUNTIF(a7:a64,"G")
That should work!
Michael

What do you actually want to count?

The no of times each name occurs or the total number of names?

As to counting by colour there are various posts on this board that deal with that.

Why not try a Board Search?

Norie said:
What do you actually want to count?

The no of times each name occurs or the total number of names?

As to counting by colour there are various posts on this board that deal with that.

Why not try a Board Search?
I want to count the total number of names.

Replies
3
Views
183
Replies
12
Views
221
Replies
1
Views
165
Replies
2
Views
195
Replies
4
Views
410

1,203,541
Messages
6,056,006
Members
444,840
Latest member
RazzelDazel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back