ExcelBanter - Summing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Summing (https://www.excelbanter.com/excel-worksheet-functions/140271-summing.html)

Catherine

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?

Black country boy

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?

Catherine

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?

RagDyeR

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?

Catherine

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?

All times are GMT +1. The time now is 04:05 PM.