Count the number of highlighted cells

**Ford_Guy** · 07-16-2008, 02:24 PM

For some reason the search is not working. I want to count the number of cells that I select whether it be in one or more columns or rows. I would like the number to be displayed at the bottom of the page. I have seen this done, but I cannot recall how it was done. Do I need to write a macro or just do a modified countif formula?

**VBA Noob** · 07-16-2008, 02:27 PM

Right click the status bar and select count

http://www.bettersolutions.com/excel...B913232322.htm

VBA Noob

**Ford_Guy** · 07-16-2008, 02:31 PM

That did not work. It keeps coming up with zero for the count. I have a filter on that is looking for blanks if that makes a difference. Also, the blanks are scattered throughout the list so they have random cell numbers.

**VBA Noob** · 07-16-2008, 02:43 PM

It won't work as you suspected. If you give all the info you stand a better chance of getting an answer

Would a formula work

=COUNTBLANK(A2:A21)

VBA Noob

**VBA Noob** · 07-16-2008, 03:03 PM

Maybe

Please Login or Register  to view this content.

VBA Noob

**Ford_Guy** · 07-16-2008, 03:10 PM

That doesn't seem to work. I am pasting it into the current workbook selection in the VBA code editor so it should, and the code does make sense. I really do not see why it does not work.

**VBA Noob** · 07-16-2008, 03:12 PM

Code goes in a normal module.

Press Alt + F11 to open VB > select Insert Module and paste > close editor press Alt + F8 and call CntCells

VBA Noob

**Ford_Guy** · 07-16-2008, 03:13 PM

I got it to run, but it is essentially counting the last number on the filter and subtracting the first from it. (i.e. The last item is number 76 and the first one is 33. The answer you get is 43. However, there are only 6 cells after I run the filter.

**VBA Noob** · 07-16-2008, 03:18 PM

Originally Posted by Ford_Guy

I got it to run, but it is essentially counting the last number on the filter and subtracting the first from it. (i.e. The last item is number 76 and the first one is 33. The answer you get is 43. However, there are only 6 cells after I run the filter.

You started off asking to count selected cells. Are you now asking to subtract the first filtered value from the last filtered Item

Maybe you need to upload an example or have a thing about what you want

VBA Noob

**Ford_Guy** · 07-16-2008, 03:26 PM

I do want it count the selected cells. I was telling you what it was doing. It isn't counting them. It is doing some sort of subtraction. The file is too big to attach right now. I will make it smaller tomorrow. I hope that explanation helps, but if not I will go into more detail when I have more time.

**VBA Noob** · 07-16-2008, 03:41 PM

I do want it count the selected cells

Not what your title says.

The file is too big to attach right now

You don't have to attach the actual file. Just a small amount of data with the expected results

VBA Noob

**olasa** · 07-16-2008, 04:07 PM

If you want to count the number of visible cells after using Autofilter, then use the formula =SUBTOTAL(3,A2:A100).
If you want to count Only Numbers, use number 4 instead of 3 in the formula. And if you want to summarise, use number 9.

Hope this helps
Ola