I am making MIS tracker

[Guest]

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
(e-mail address removed)

 

[Dave Peterson]

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

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
(e-mail address removed)