Formula
Solved/Closed
Jmccall2016
Posts
4
Registration date
Wednesday June 14, 2017
Status
Member
Last seen
June 15, 2017
-
Jun 14, 2017 at 09:46 AM
x - Jun 15, 2017 at 01:13 PM
x - Jun 15, 2017 at 01:13 PM
Related:
- Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 14, 2017 at 10:53 AM
Jun 14, 2017 at 10:53 AM
Jennifer, Good morning.
Suppose your range of data:
A1:A100
Try to use:
=COUNTBLANK(A1:A100)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your range of data:
A1:A100
Try to use:
=COUNTBLANK(A1:A100)
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jmccall2016
Posts
4
Registration date
Wednesday June 14, 2017
Status
Member
Last seen
June 15, 2017
Jun 14, 2017 at 12:47 PM
Jun 14, 2017 at 12:47 PM
How can I add all the blanks if they are not in order? The data I am requesting is say A1, B1, D1, F1.. etc?
Jmccall2016
Posts
4
Registration date
Wednesday June 14, 2017
Status
Member
Last seen
June 15, 2017
Jun 14, 2017 at 01:13 PM
Jun 14, 2017 at 01:13 PM
If you can see the picture the formula is not adding up just the blanks. :(Thank you for your help with this.
Jmccall2016
Posts
4
Registration date
Wednesday June 14, 2017
Status
Member
Last seen
June 15, 2017
Jun 15, 2017 at 10:52 AM
Jun 15, 2017 at 10:52 AM
There is nothing in the cells. They are infact blank.
