| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am making 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I am making MIS tracker
Your post came through as plain text to me.
But if you want to read about =vlookup() and =countif(), visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions04.html#CountIf Raj wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I stop excel from automatically making hyperlinks | Excel Discussion (Misc queries) | |||
| 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) | |||
| Making a chart | Charts and Charting in Excel | |||
| Making Mailing Labels | Links and Linking in Excel | |||
Linear Mode
