| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am making MIS tracker | Excel Discussion (Misc queries) | |||
| Date Vacation Tracker | Excel Worksheet Functions | |||
| How to publish 2004 European soccer championship tracker template? | Excel Discussion (Misc queries) | |||
| employee annual sick leave tracker with hours owing not used | Excel Discussion (Misc queries) | |||
| Does any know how to add more columns in the NCAA Excel Tracker? | Excel Discussion (Misc queries) | |||
Linear Mode
