Question on Count

[frnd4kumar]

Is there any way (like countifs function) to count number of blanks in a column provided a number is present in the previous column, Ex. In the ninth row, the data for 2011 is blank but the previous column some data is present, is there any way I can count such instances using a fuction.


[TABLE="width: 144"]


<colgroup><col style="width: 48pt;" span="3" width="64">
<tbody>[TR]

[TD="class: xl66, width: 64, bgcolor: #948A54"]2010[/TD]

[TD="class: xl66, width: 64, bgcolor: #948A54, align: right"]2011[/TD]

[TD="class: xl66, width: 64, bgcolor: #948A54, align: right"]2012[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]5[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]19[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]7[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl65, bgcolor: yellow, align: right"]4[/TD]

[TD="class: xl65, bgcolor: yellow"] [/TD]

[TD="class: xl65, bgcolor: yellow"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]23[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]27[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]10[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]10[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]12[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]3[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]11[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]10[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]6[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]5[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]8[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]44[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]14[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]19[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]10[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]8[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]17[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]13[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]5[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]13[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]46[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]13[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]65[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]64[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]5[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]68[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]8[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]19[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]8[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]21[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]36[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]14[/TD]

[/TR]

[TR]

[TD="class: xl64, bgcolor: transparent, align: right"]31[/TD]

[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]

[TD="class: xl64, bgcolor: transparent"] [/TD]

[/TR]


</tbody>[/TABLE]

 

[Aladin Akyurek]

Not clear whether you want a count for 2011 and another for 2012...

For 2011:

=COUNTIFS(A2:A23,"<>",B2:B23,"=")

Copy across for 2012.

 

[frnd4kumar]

Not clear whether you want a count for 2011 and another for 2012...

For 2011:

=COUNTIFS(A2:A23,"<>",B2:B23,"=")

Copy across for 2012.

Wow....this is working....thanks a lot....It has been helpful for me....

 

[Aladin Akyurek]

Wow....this is working....thanks a lot....It has been helpful for me....

You are welcome. Thanks for providing feedback.