Formula
Solved/Closed
Jmccall2016
Posts
4
Registration date
Wednesday 14 June 2017
Status
Member
Last seen
15 June 2017
-
14 Jun 2017 à 09:46
x - 15 Jun 2017 à 13:13
x - 15 Jun 2017 à 13:13
Related:
- Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
14 Jun 2017 à 10:53
14 Jun 2017 à 10:53
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 14 June 2017
Status
Member
Last seen
15 June 2017
14 Jun 2017 à 12:47
14 Jun 2017 à 12:47
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 14 June 2017
Status
Member
Last seen
15 June 2017
14 Jun 2017 à 13:13
14 Jun 2017 à 13:13
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 14 June 2017
Status
Member
Last seen
15 June 2017
15 Jun 2017 à 10:52
15 Jun 2017 à 10:52
There is nothing in the cells. They are infact blank.
