Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 63
Default How do i get the total count

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



"Stefi" wrote:

You are welcome! Thanks for the feedback!
Stefi

€˛Ravi€¯ ezt Ć*rta:

thanks a ton stefi....................

"Stefi" wrote:

In Table 1 Status being in Col A, Regions in B and C
=SUMPRODUCT(--(Table2!$G$2:$G$11=$A2),--(Table2!$C$2:$C$11=B$1))
Fill it to the right and down!

Regards,
Stefi


€˛Ravi€¯ ezt Ć*rta:

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)..please help

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

TABLE : 2
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get the Total count Ravi Excel Discussion (Misc queries) 6 July 30th 08 08:11 AM
count each row for total matches Jace New Users to Excel 3 December 25th 07 12:45 PM
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel Excel Worksheet Functions 6 September 28th 06 11:59 PM
TO COUNT & TOTAL IT Ashwini Excel Worksheet Functions 1 September 7th 06 12:28 PM
How do i count numbers and letters to find a total count of all Linda Excel Worksheet Functions 4 November 10th 05 05:51 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"