COUNTIF/S multiple criteria incl. blank cells

[buka]

I have been trying to figure out if the COUNTIF/S formula can handle a blank cell criteria.
I want to know how many from each State Division have not paid from the simplified table below...??

<table style="border-collapse: collapse; width: 178pt;" border="0" cellpadding="0" cellspacing="0" width="237"><col style="width: 28pt;" width="37"> <col style="width: 68pt;" width="91"> <col style="width: 82pt;" width="109"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; width: 28pt;" align="center" width="37" height="17">
</td> <td class="xl69" style="border-left: medium none; width: 68pt;" align="center" width="91">A</td> <td class="xl69" style="border-left: medium none; width: 82pt;" align="center" width="109">B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">1</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">DIVISION</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="center">DATE PAID</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">2</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">QLD</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">12-Jun-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">3</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">WA</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">06-Apr-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">4</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">VIC</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">5</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">VIC</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">05-Aug-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">6</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">NSW</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">7</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">VIC</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">8</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">NSW</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">12-Jul-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">9</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">QLD</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">31-May-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">10</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">NSW</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">11</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">NSW</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl69" style="height: 12.75pt; border-top: medium none;" align="center" height="17">12</td> <td class="xl71" style="border-top: medium none; border-left: medium none;" align="center">WA</td> <td class="xl72" style="border-top: medium none; border-left: medium none;" align="center">15-Jun-10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" align="center" height="17">
</td> <td class="xl66" align="center">
</td> <td align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" align="center" height="17">
</td> <td class="xl67" align="center">Unpaid NSW</td> <td class="xl68" align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" align="center" height="17">
</td> <td class="xl67" align="center">Unpaid QLD</td> <td align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" align="center" height="17">
</td> <td class="xl67" align="center">Unpaid VIC</td> <td align="center">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl66" style="height: 12.75pt;" align="center" height="17">
</td> <td class="xl67" align="center">Unpaid WA</td> <td align="center">
</td> </tr> </tbody></table>
I'm sure there's a simple solution but I've been breaking my head trying to combine COUNTIF and COUNTBLANK with out getting the correct solution.

Thanks in advance for anyone who can help me here...
Rgds,

 

[pagrender]

It worked when I tried this formula:
=COUNTIFS($A$2:$A$12,A15,$B$2:$B$12,"")

 

[sulakvea]

you are using COUNTIFS - so i assume you have Xl 2007 or later. not sure if they added a version of countif that would handle smth like that, but with good old Xl 2003 this is the way to do it:

=SUMPRODUCT((A2:A17="QLD")*(B2:B17=""))

change the range and conditions (="QLD") to suit your needs

 

[buka]

Many thanks for your prompt replies, the SUMPRODUCT formula works -trying to figure why the COUNTIFS doesn't.
Yes Excel 2007.
Rgds,

 

[ESigman]

Good morning, Mr. Excel. I would like to do a countifs but with multiple blank cells. =Countifs(I:I,"Eric",O:S,"") How do you execute a countifs with blank cells over a series? Thank you in advance.