formula to count data based on Account

[vikkhe1]

Hi All,

Kindly find the attached file in which I need formula to count data based on Account.




The attached sheet will self-explain the exact requirement.




Your help in this regards will be highly appreciated.

<tbody>
[TD="class: xl63"]Desk Location[/TD]
[TD="class: xl63, width: 54"]Emp. ID[/TD]
[TD="class: xl63, width: 224"]Employee Name[/TD]
[TD="class: xl63, width: 141"]Account[/TD]
[TD="class: xl66, width: 141"][/TD]
[TD="class: xl66, width: 101"][/TD]
[TD="class: xl66, width: 110"][/TD]
[TD="class: xl66, width: 89"][/TD]

[TD="class: xl64"]P4001[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl63"]Account[/TD]
[TD="class: xl65, width: 110"]Employee
Count[/TD]
[TD="class: xl63"]#N/A Count[/TD]

[TD="class: xl64"]P4002[/TD]
[TD="class: xl64"]123[/TD]
[TD="class: xl64"]ABC[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl64"]4[/TD]
[TD="class: xl64"]2[/TD]

[TD="class: xl64"]P4003[/TD]
[TD="class: xl64"]345[/TD]
[TD="class: xl64"]BCA[/TD]
[TD="class: xl64"]Procurment[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl64"]Procurment[/TD]
[TD="class: xl64"]3[/TD]
[TD="class: xl64"]0[/TD]

[TD="class: xl64"]P4004[/TD]
[TD="class: xl64"]567[/TD]
[TD="class: xl64"]CAB[/TD]
[TD="class: xl64"]Procurment[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl64"]Finance[/TD]
[TD="class: xl64"]2[/TD]
[TD="class: xl64"]1[/TD]

[TD="class: xl64"]P4005[/TD]
[TD="class: xl64"]890[/TD]
[TD="class: xl64"]CAD[/TD]
[TD="class: xl64"]Procurment[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl64"]HR[/TD]
[TD="class: xl64"]1[/TD]
[TD="class: xl64"]3[/TD]

[TD="class: xl64"]P4006[/TD]
[TD="class: xl64"]1234[/TD]
[TD="class: xl64"]CAF[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4007[/TD]
[TD="class: xl64"]1235[/TD]
[TD="class: xl64"]CVF[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4008[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4009[/TD]
[TD="class: xl64"]1237[/TD]
[TD="class: xl64"]BGM[/TD]
[TD="class: xl64"]Finance[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4010[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]Finance[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4011[/TD]
[TD="class: xl64"]1239[/TD]
[TD="class: xl64"]BVM[/TD]
[TD="class: xl64"]Finance[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4012[/TD]
[TD="class: xl64"]1230[/TD]
[TD="class: xl64"]MVB[/TD]
[TD="class: xl64"]HR[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4013[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]HR[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4014[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]HR[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4015[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]#N/A[/TD]
[TD="class: xl64"]HR[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl64"]P4024[/TD]
[TD="class: xl64"]1244[/TD]
[TD="class: xl64"]VNK[/TD]
[TD="class: xl64"]Administration[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

</tbody>

Regards,

Vikkhe1

 

[alansidman]

You will need to use the = Countifs function. Look at this link on how to use it.

https://www.techonthenet.com/excel/formulas/countifs.php