Help with formula please [Solved/Closed]

Report
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017
-
CB7373
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017
-
Hi, please could someone help me with a formula to add up cells that have data in them.
My spreadsheet has data in columns B-N - some of them have 'A', some have 'B', some 'C' etc loaded into the cell. Some of the cells are blank. I would like to add up the cells with data in them in the final column O but not include the cells which are blank.

Help please?

Thanks in advance!

Cathy

4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Cathy, Good morning.

Try to use:

O1 --> =COUNTA(B1:N1)

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
CB7373
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017

Hi, thanks for helping!
The values in the cells are not numbers, they are letters and I would like to add up the cells with a letter in the cell. This has not worked for me. Any other ideas?
CB7373
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017

Sorry my mistake, that worked! Thanks!!