Assuming Table 1 is in A1:F20, and table 2 is in A23:C28

=SUMPRODUCT(--($F$1:$F$20=$A24),--($D$1:$D$20=B$23))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ravi" wrote in message
...
Hi .........I have two tables like the below ( i have hundreds of data
below
is the
example) and i want to count the current status count in chennai or Delhi
coloumn (whereever zero) if i change the status in current status coloumn
in
TABLE 2 then the total count will automatically calculate in TABLE 1
chennai
or Delhi
fileld (i tried Countif function but i am not able to get the correct
count)

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

thanks in advance

ravi kumar