|
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 |
| All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com