R
Ravi
Hi .........one more clarification needed, i have two categories ( it
may be 3 or 4 also ) in TABLE 2 if i count the current status in TABLE 2 to
get the count in TABLE 1 if i have two categories it should be consided as 1
find the example below
please help............
Eg : Actual count should like this
Yet to Start 1
Delivered 3
Pending 1
In Process 2
Total 7
After putting formula it like this
Yet to Start 2
Delivered 4
Pending 2
In Process 2
Total 10
TABLE : 1
Status Chennai Delhi
Yet to Start 0 0
In Process 0 0
Pending 0 0
Delivered 0 0
Total 0 0
TABLE : 2
Sl # Project # Category Region QC Current Status
1 101 C06 Chennai Ravi Yet to Start
101 INP Chennai Ravi Yet to Start
2 103 C06 Chennai Ravi Delivered
103 INP Chennai Ravi Delivered
3 105 C07 Chennai Ravi Pending
105 INS Delhi Ravi Pending
4 107 C08 Delhi Ravi Delivered
5 108 C09 Delhi Ravi Delivered
6 109 C08 Delhi Ravi In Process
7 110 C08 Delhi Ravi In Process
may be 3 or 4 also ) in TABLE 2 if i count the current status in TABLE 2 to
get the count in TABLE 1 if i have two categories it should be consided as 1
find the example below
please help............
Eg : Actual count should like this
Yet to Start 1
Delivered 3
Pending 1
In Process 2
Total 7
After putting formula it like this
Yet to Start 2
Delivered 4
Pending 2
In Process 2
Total 10
TABLE : 1
Status Chennai Delhi
Yet to Start 0 0
In Process 0 0
Pending 0 0
Delivered 0 0
Total 0 0
TABLE : 2
Sl # Project # Category Region QC Current Status
1 101 C06 Chennai Ravi Yet to Start
101 INP Chennai Ravi Yet to Start
2 103 C06 Chennai Ravi Delivered
103 INP Chennai Ravi Delivered
3 105 C07 Chennai Ravi Pending
105 INS Delhi Ravi Pending
4 107 C08 Delhi Ravi Delivered
5 108 C09 Delhi Ravi Delivered
6 109 C08 Delhi Ravi In Process
7 110 C08 Delhi Ravi In Process