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
rajiv999@emirates.net.ae
Bookmarks