Help with formula please [Solved]

CB7373 3 Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen - Sep 19, 2017 at 08:53 AM - Latest reply: CB7373 3 Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen
- Sep 19, 2017 at 11:16 AM
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
See more 

Your reply

3 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Sep 19, 2017 at 09:40 AM
0
Thank you
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 3 Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen - Sep 19, 2017 at 09:43 AM
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 3 Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen - Sep 19, 2017 at 11:16 AM
Sorry my mistake, that worked! Thanks!!
Respond to Mazzaropi