<tbody>
Dear Sir,
I want to count state wise status of billed or not billed,i am applying countifs but its not working.
Example
SHEET:1
<tbody>
State
Status
ASSAM
BILLED
ASSAM
NOT BILLED
ASSAM
BILLED
CHANDIGARH
BILLED
CHANDIGARH
NOT BILLED
</tbody>
</tbody>
ANS:
<tbody>...