Report

Help with formula please [Solved]

Ask a question CB7373 3Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen - Last answered on Sep 19, 2017 at 11:16 AM by CB7373
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
Helpful
+0
plus moins
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 3Posts 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?
Reply
CB7373 3Posts Tuesday September 19, 2017Registration date September 19, 2017 Last seen - Sep 19, 2017 at 11:16 AM
Sorry my mistake, that worked! Thanks!!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!