Thread: help extending formula to range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgd pgd is offline
external usenet poster
  
Posts: 1
Default help extending formula to range

I am stuck with extending the formula to a range in a column. I need to
implement a "for loop" for the formula below..... Help!!!

This works:
=IF(C2="ABC",IF(D2="XYZ",COUNTIF(Q2,"done")))

I want something like:
=IF(C3:C1000="ABC",IF(D3:D1000="XYZ",COUNTIF(Q3:Q1 000,"done")))

Thanks in advance for your help!


--
pgd
------------------------------------------------------------------------
pgd's Profile: http://www.excelforum.com/member.php...o&userid=28141
View this thread: http://www.excelforum.com/showthread...hreadid=476569

Reply With QuoteReply With Quote