I am making MIS tracker

Giganews Newsgroups
Subject: I am making MIS tracker
Posted by:  raj
Date: Wed, 24 May 2006

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

    [B]A[/B]
[B]Unit[/B]
[B]Status[/B]
[I]Van[/I]
Pending
[I]Direct Sales[/I]
Pending
[I]BSSM[/I]
Approved
[I]PC [/I]
Declined
[I]Telesales [/I]
Approved
[I]Investments[/I]
Pending
[I]Telesales[/I]
Approved
[I]Investments [/I]
Declined
[I]Van [/I]
  Pending
[I]Direct Sales[/I]
Pending
[I]Van [/I]
  Approved

On the Next sheet 2

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

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

Could you please tell me the formula or email me on
[email]rajiv9…@emirates.net.ae[/email]

Replies