Previous Topic Next Topic

Help with formula please

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

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 19, 2017 at 09:40 AM
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
0
CB7373 Posts 3 Registration date Tuesday September 19, 2017 Status Member Last seen September 19, 2017
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?
0
CB7373 Posts 3 Registration date Tuesday September 19, 2017 Status Member Last seen September 19, 2017
Sep 19, 2017 at 11:16 AM
Sorry my mistake, that worked! Thanks!!
0

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
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response