View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Rajesh Rajesh is offline
external usenet poster
 
Posts: 47
Default 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.