Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
Hi,
I have datas in cell range A1:C4, where A being name of the projects (one project may occur in two or more places), B being the task number, C being week for completion of the task. Now I have to count the number of cells with given week of completion in a given project. This is to identify the number of tasks in a particular week in a particular project. How shall I do this. Please help me with ideas. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
=SUMPRODUCT(--(A1:A4="project"),--(C1:C4=week_num))
-- __________________________________ HTH Bob "Rajesh" wrote in message ... Hi, I have datas in cell range A1:C4, where A being name of the projects (one project may occur in two or more places), B being the task number, C being week for completion of the task. Now I have to count the number of cells with given week of completion in a given project. This is to identify the number of tasks in a particular week in a particular project. How shall I do this. Please help me with ideas. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
Thanks philips for your reply. But I am not getting the desired result when I
checked with an example. Whether sumproduct can be used to count the desired data from the array? "Bob Phillips" wrote: =SUMPRODUCT(--(A1:A4="project"),--(C1:C4=week_num)) -- __________________________________ HTH Bob "Rajesh" wrote in message ... Hi, I have datas in cell range A1:C4, where A being name of the projects (one project may occur in two or more places), B being the task number, C being week for completion of the task. Now I have to count the number of cells with given week of completion in a given project. This is to identify the number of tasks in a particular week in a particular project. How shall I do this. Please help me with ideas. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
To be more clear on my problem:
ProjectA Task1 Week1 ProjectB Task1 week2 ProjectA Task2 Week2 ProjectB Task2 Week1 ProjectA Task3 Week1 If these are my datas, then if my request is counting the number of datas with "ProjectA" and "Week1", the result should be 2. "Rajesh" wrote: Thanks philips for your reply. But I am not getting the desired result when I checked with an example. Whether sumproduct can be used to count the desired data from the array? "Bob Phillips" wrote: =SUMPRODUCT(--(A1:A4="project"),--(C1:C4=week_num)) -- __________________________________ HTH Bob "Rajesh" wrote in message ... Hi, I have datas in cell range A1:C4, where A being name of the projects (one project may occur in two or more places), B being the task number, C being week for completion of the task. Now I have to count the number of cells with given week of completion in a given project. This is to identify the number of tasks in a particular week in a particular project. How shall I do this. Please help me with ideas. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
As Bob said =SUMPRODUCT(--(A1:A4="projecta"),--(C1:C4="week1")) -- Pecoflyer Cheers - MS Excel Newbie ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=40100 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
To count the data using multiple criteria in multiple columns
Thank you all. It works.
"Pecoflyer" wrote: As Bob said =SUMPRODUCT(--(A1:A4="projecta"),--(C1:C4="week1")) -- Pecoflyer Cheers - MS Excel Newbie ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=40100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count across multiple columns, using specific criteria | Excel Discussion (Misc queries) | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
How can I count items in multiple columns with different criteria. | Excel Worksheet Functions | |||
Sum Count of Single Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions |