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

Thanks in advance for your help!

[Gary Keramidas]

i think this will work

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

--


Gary


"pgd" <pgd.1wz8ea_1129435503.4226@excelforum-nospam.com> wrote in message
news:pgd.1wz8ea_1129435503.4226@excelforum-nospam.com...
>
> 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:Q1000,"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
>

[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

--


Gary


"pgd" <pgd.1wzmad_1129453507.5911@excelforum-nospam.com> wrote in message
news:pgd.1wzmad_1129453507.5911@excelforum-nospam.com...
>
> 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
>

[pgd]

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

D