Thread: To count the data using multiple criteria in multiple columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Pecoflyer[_44_] Pecoflyer[_44_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote