ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stupid counting question!! (https://www.excelbanter.com/excel-discussion-misc-queries/66196-stupid-counting-question.html)

NotIT

Stupid counting question!!
 
I know this is dumb, but it's driving me nuts - one of my co-workers has a
spreadsheet and if he highlights a group of cells with his mouse, the number
of cells he has highlighted automatically comes up on the bottom of his
screen - it says "Count=11" or however many cells he highlighted.

It doesn't add the number IN the cells, just counts whatever he highlights.
He has NO idea how he got it to do this and one of my other co-workers needs
this function on one of his spreadsheets.

I'm sure this is some stupid, easy thing, but I can NOT figure it out and
it's driving me nuts!!! I did search through the questions but either I'm
not finding this EXACT thing, or I'm not understanding it....

Thanks in advance for ANY help!!! (o:

Bill Kuunders

Stupid counting question!!
 
right click in the spot where the sum appears at the bottom of your screen
and select.........

you can cancel the appointment with your psychiatrist.


--
Greetings from New Zealand
Bill K

"NotIT" wrote in message
...
I know this is dumb, but it's driving me nuts - one of my co-workers has a
spreadsheet and if he highlights a group of cells with his mouse, the
number
of cells he has highlighted automatically comes up on the bottom of his
screen - it says "Count=11" or however many cells he highlighted.

It doesn't add the number IN the cells, just counts whatever he
highlights.
He has NO idea how he got it to do this and one of my other co-workers
needs
this function on one of his spreadsheets.

I'm sure this is some stupid, easy thing, but I can NOT figure it out and
it's driving me nuts!!! I did search through the questions but either I'm
not finding this EXACT thing, or I'm not understanding it....

Thanks in advance for ANY help!!! (o:




Ron Coderre

Stupid counting question!!
 
Try this:
Right-Click in the status bar (at the bottom of the Excel window).
Select the function you want to be used.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"NotIT" wrote:

I know this is dumb, but it's driving me nuts - one of my co-workers has a
spreadsheet and if he highlights a group of cells with his mouse, the number
of cells he has highlighted automatically comes up on the bottom of his
screen - it says "Count=11" or however many cells he highlighted.

It doesn't add the number IN the cells, just counts whatever he highlights.
He has NO idea how he got it to do this and one of my other co-workers needs
this function on one of his spreadsheets.

I'm sure this is some stupid, easy thing, but I can NOT figure it out and
it's driving me nuts!!! I did search through the questions but either I'm
not finding this EXACT thing, or I'm not understanding it....

Thanks in advance for ANY help!!! (o:


NotIT

Stupid counting question!!
 
LOL! Thank you, man I knew it was a simple step but of course I could NOT
remember or figure it out!!!!

"Bill Kuunders" wrote:

right click in the spot where the sum appears at the bottom of your screen
and select.........

you can cancel the appointment with your psychiatrist.


--
Greetings from New Zealand
Bill K

"NotIT" wrote in message
...
I know this is dumb, but it's driving me nuts - one of my co-workers has a
spreadsheet and if he highlights a group of cells with his mouse, the
number
of cells he has highlighted automatically comes up on the bottom of his
screen - it says "Count=11" or however many cells he highlighted.

It doesn't add the number IN the cells, just counts whatever he
highlights.
He has NO idea how he got it to do this and one of my other co-workers
needs
this function on one of his spreadsheets.

I'm sure this is some stupid, easy thing, but I can NOT figure it out and
it's driving me nuts!!! I did search through the questions but either I'm
not finding this EXACT thing, or I'm not understanding it....

Thanks in advance for ANY help!!! (o:





NotIT

Stupid counting question!!
 
Ugh, I knew it would be something easy - thank you SO much!!!!

"Ron Coderre" wrote:

Try this:
Right-Click in the status bar (at the bottom of the Excel window).
Select the function you want to be used.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"NotIT" wrote:

I know this is dumb, but it's driving me nuts - one of my co-workers has a
spreadsheet and if he highlights a group of cells with his mouse, the number
of cells he has highlighted automatically comes up on the bottom of his
screen - it says "Count=11" or however many cells he highlighted.

It doesn't add the number IN the cells, just counts whatever he highlights.
He has NO idea how he got it to do this and one of my other co-workers needs
this function on one of his spreadsheets.

I'm sure this is some stupid, easy thing, but I can NOT figure it out and
it's driving me nuts!!! I did search through the questions but either I'm
not finding this EXACT thing, or I'm not understanding it....

Thanks in advance for ANY help!!! (o:



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com