Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I highlight a block of cells the total would show at the bottom right of
the screen. Now, when I highlight the cells, I get 'Count = x" instead of $sum. Why and how to fix. Thanks! |
#2
![]() |
|||
|
|||
![]()
Hi PTFisher
Right click on "'Count = x" and change it -- Regards Ron de Bruin http://www.rondebruin.nl "PTFisher" wrote in message ... When I highlight a block of cells the total would show at the bottom right of the screen. Now, when I highlight the cells, I get 'Count = x" instead of $sum. Why and how to fix. Thanks! |
#3
![]() |
|||
|
|||
![]()
right-click sum= at the bottom of the window and select what you want.
-- Gary's Student "PTFisher" wrote: When I highlight a block of cells the total would show at the bottom right of the screen. Now, when I highlight the cells, I get 'Count = x" instead of $sum. Why and how to fix. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count cells with length not equal to 7 | Excel Worksheet Functions | |||
count cells with unique numbers | Excel Worksheet Functions | |||
Count highlighted cells | Excel Worksheet Functions | |||
How can empty cells automatically highlight after 24 hours? | Excel Worksheet Functions | |||
how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions |