Row / Cell Count

kurtmaz

New Member
Joined
Oct 16, 2006
Messages
2
I often times find myself highlighting a series of rows to see how many times a certain value appears. For example, let's say I have a spreadsheet of my contacts. I have sorted on a City column. I want to be able to just highlight the cells that contain 'Minneapolis' and see a count somewhere. As it stands now, I have to look at the row numbers that are highlighted and do some simple math or try to plug in a function in some other cell. Is there a simple way to see a count?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Welcome to the board.
Have you tried the COUNTIF function?
Like:

Countif(range,criteria)
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Kurtmaz

Welcome to the Board!

Your status bar (which should be at the bottom of your screen above the Windows Task Bar) has the facility to summarise selected ranges based on seetings you choose (default is to Sum). This however can be changed by right-clicking on it and selecting eg Count from the dialog list that comes up. In an autofiltered list, this will only count the selected and visible cells, providing a handy way of checking how many results you have.

Best regards

Richard
 

kurtmaz

New Member
Joined
Oct 16, 2006
Messages
2
Thanks Richard Schollar

That is exactly what I was looking for. Appreciate the help.
 

Forum statistics

Threads
1,144,370
Messages
5,723,966
Members
422,529
Latest member
mbilal429

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top