Count the party name

[jollysalman]

<table style="border-collapse: collapse; width: 251px; height: 323px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 89pt;" width="118"> <col style="width: 89pt;" width="119"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 89pt;" width="118" height="20">CELL</td> <td style="width: 89pt;" width="119">PARTY NAME</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A1</td> <td class="xl65">ABC</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A2</td> <td class="xl65">ABC</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A3</td> <td class="xl65">ABC</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A4</td> <td>CBS</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A5</td> <td>CCS</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A6</td> <td class="xl65">CSB</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A7</td> <td class="xl65">CSB</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A8</td> <td>SBC</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A9</td> <td class="xl65">SCB</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A10</td> <td class="xl65">SCB</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">A11</td> <td>SEV</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>=COUNTA(B1:B11)</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Answer</td> <td align="right">11</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Iwant the Answer</td> <td align="right">7</td> </tr> </tbody></table>

 

[planetpj]

Try this
=SUM(COUNTIF(A1:A11,{"ABC","CSB","SCB"}))

 

[jollysalman]

thanks for ur reply but it is not that formula what i want. because if time the party name change and that case that formula is wrong.

 

[repairman615]

Maybe I understand:

=SUM(IF(D1="",0,COUNTIF(A1:A11,C1)),IF(D2="",0,COUNTIF(A1:A11,C2)),IF(D3="",0,COUNTIF(A1:A11,C3)),IF(D4="",0,COUNTIF(A1:A11,C4)),IF(D5="",0,COUNTIF(A1:A11,C5)))

Column C in the cells c1:c5 is this party name list.

Column D in the cells d1:d5 are blank or empty.
This column is used for toggle on and off of listed party names to count from column C.

Typing anything in column D (next to the listed party names in column C)
will count that party name to the left.

This formula will handle up to five different names.