help extending formula to range

[pgd]

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(D31000="XYZ",COUNTIF(Q3:Q1000,"done")))

Thanks in advance for your help!

 

[Gary Keramidas]

i think this will work

=SUM(IF(C3:C1000="ABC",IF(D31000="XYZ",IF(Q3:Q1000="done",1,0))))

 

[pgd]

The formula result is evaluated correctly, Thanks!

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

 

[Gary Keramidas]

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

 

[pgd]

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