| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing
I summed a column. When I highlight the cell where the total is supposed to
go, the answer is there. When I don't, it's not. What did I do wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing
It could be that the cell has been formatted as white text.
Check that your font colour for the cell is set at Automatic. BCB "Catherine" wrote: I summed a column. When I highlight the cell where the total is supposed to go, the answer is there. When I don't, it's not. What did I do wrong? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing
I checked that already, but it wasn't. Any other ideas?
"Black country boy" wrote: It could be that the cell has been formatted as white text. Check that your font colour for the cell is set at Automatic. BCB "Catherine" wrote: I summed a column. When I highlight the cell where the total is supposed to go, the answer is there. When I don't, it's not. What did I do wrong? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing
Did you check "Conditional Formatting"?
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Catherine" wrote in message ... I checked that already, but it wasn't. Any other ideas? "Black country boy" wrote: It could be that the cell has been formatted as white text. Check that your font colour for the cell is set at Automatic. BCB "Catherine" wrote: I summed a column. When I highlight the cell where the total is supposed to go, the answer is there. When I don't, it's not. What did I do wrong? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing
There is a conditional format for those cells, but it only applies if the
value isn't a number. "Ragdyer" wrote: Did you check "Conditional Formatting"? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Catherine" wrote in message ... I checked that already, but it wasn't. Any other ideas? "Black country boy" wrote: It could be that the cell has been formatted as white text. Check that your font colour for the cell is set at Automatic. BCB "Catherine" wrote: I summed a column. When I highlight the cell where the total is supposed to go, the answer is there. When I don't, it's not. What did I do wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
| summing up | Charts and Charting in Excel | |||
| Summing | Excel Worksheet Functions | |||
| Summing all BUT one... | Excel Worksheet Functions | |||
| Help with summing | Excel Worksheet Functions | |||
Linear Mode
