MIS tracker
 

Hello people,
I am making MIS tracker. I want the Vlook and CountIF formula. I mean how to
use it and if someone can tell me where am I wrong.

Sheet 1

A
Unit
Status
Van
Pending
Direct Sales
Pending
BSSM
Approved
PC
Declined
Telesales
Approved
Investments
Pending
Telesales
Approved
Investments
Declined
Van
Pending
Direct Sales
Pending
Van
Approved

On the Next sheet 2

UNIT TOTAL RECEIVED SENT PENDING PERCENTAGE
Van
Direct Sales
BSSM
PC
Telesales
Investments

The result should come on Sheet 2 as and when i enter details in sheet
1

Could you please tell me the formula or email me on