Formula required to get the correct count.

R

Ravi

Hi, I have data like the below ( hundreds of data below is the example) and i
want to count the current status count into chennai or Delhi coloumn
(whereever zero) if i change the status in current status coloumn that will
automatically calculate in chennai or Delhi fileld (i tried Countif function
but i am not able to get the correct count)..please help

Status Chennai Delhi
Yet to Start 0 0
In Process 0 0
Pending - External 0 0
Delivered 0 0
Total 0 0

Sl # Project # Region Start Date End Date QC Current Status
1 101 Chennai 07/09/2008 07/09/2008 Ravi Yet to Start
2 102 Chennai 07/09/2008 07/09/2008 Ravi Yet to Start
3 103 Chennai 07/10/2008 07/10/2008 Ravi Delivered
4 104 Chennai 07/10/2008 07/10/2008 Ravi Delivered
5 105 Chennai 07/10/2008 07/10/2008 Ravi Pending - External
6 106 Delhi 07/10/2008 07/10/2008 Ravi Pending - External
7 107 Delhi 07/09/2008 07/09/2008 Ravi Delivered
8 108 Delhi 07/11/2008 07/11/2008 Ravi Delivered
9 109 Delhi 07/11/2008 07/11/2008 Ravi In Process
10 110 Delhi 07/11/2008 07/11/2008 Ravi In Process

Thanks
regards
Ravi Kumar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get the Total count 6
Sumproduct how can i use 3
How do i get the total count 0
How to count the occurrence? 3
Date Count ! 7
Advanced problem using auto-number and datediff to find readmissio 2
Need a formula/Macro 3
Modifying a complex date formual to count months 4

Top