Thread: Looking in one col, counting in another. OFFSET?INDEX? Help!!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Looking in one col, counting in another. OFFSET?INDEX? Help!!
Hi Justin,

Assuming your data is in column A and B you can use

=SUMPRODUCT((A1:A8="Open")*(B1:B8=C1))/COUNTIF(B1:B8,C1)

To get the pct of Open on a date entered in C1

Regards,
Bondi

Reply With QuoteReply With Quote