Help with formula please [Solved/Closed]

Report
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017
-
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

1 reply

Posts
1923
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 29, 2021
143
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
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?
Posts
3
Registration date
Tuesday September 19, 2017
Status
Member
Last seen
September 19, 2017

Sorry my mistake, that worked! Thanks!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!