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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
total list of names
- Thread starter archigirl
- Start date
daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
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
=COUNTIF(a7:a64,"A")
=COUNTIF(a7:a64,"B")
=COUNTIF(a7:a64,"G")
That should work!
Michael
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,376
- Office Version
- 365
- Platform
- Windows
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?
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?
Upvote
0
Similar threads
- Solved
- Solved
