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

help extending formula to range
 

i think this will work

=SUM(IF(C3:C1000="ABC",IF(D3:D1000="XYZ",IF(Q3:Q10 00="done",1,0))))

--


Gary


"pgd" wrote in message
...

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

help extending formula to range
 

The formula result is evaluated correctly, Thanks!

However, I still have an issue - the value displayed is "0". The cell
format is "general".


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

help extending formula to range
 

sorry, it's an array formula. after you enter it, do control-shift-enter
instead of enter

--


Gary


"pgd" wrote in message
...

The formula result is evaluated correctly, Thanks!

However, I still have an issue - the value displayed is "0". The cell
format is "general".


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

help extending formula to range
 

cool! got it to work. Thanks very much!!!



--
pg
-----------------------------------------------------------------------
pgd's Profile: http://www.excelforum.com/member.php...fo&userid=2814
View this thread: http://www.excelforum.com/showthread.php?threadid=47656