Previous Topic Next Topic

Help with formula please

Solved/Closed
CB7373 Posts 3 Registration date Tuesday 19 September 2017 Status Member Last seen 19 September 2017 - 19 Sep 2017 à 08:53
CB7373 Posts 3 Registration date Tuesday 19 September 2017 Status Member Last seen 19 September 2017 - 19 Sep 2017 à 11:16
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 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
19 Sep 2017 à 09:40
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 19 September 2017 Status Member Last seen 19 September 2017
19 Sep 2017 à 09:43
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 19 September 2017 Status Member Last seen 19 September 2017
19 Sep 2017 à 11:16
Sorry my mistake, that worked! Thanks!!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses