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.

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.

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.

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.

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

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