| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Blanks
I need a formula which counts blanks within the range b1:b200 Ive tried countif(b1:b200,0) or countif(b1:b200,"0") neither work, any help is much appreciated -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=398138 |
|
#2
|
|||
|
|||
|
T De Villiers Wrote: I need a formula which counts blanks within the range b1:b200 Ive tried countif(b1:b200,0) or countif(b1:b200,"0") neither work, any help is much appreciated Try this ... =COUNTIF(B1:B200,\"=\"&\"\") Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=398138 |
|
#3
|
|||
|
|||
|
This works too... *=countif(B1:B200,"")* -- Leebo ------------------------------------------------------------------------ Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523 View this thread: http://www.excelforum.com/showthread...hreadid=398138 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
| Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
| Counting rows of blanks across certain columns | New Users to Excel | |||
| linking files with blanks | Excel Discussion (Misc queries) | |||
| Filling in blanks. | Excel Worksheet Functions | |||
Linear Mode
