HELP! countif

[addicted]

I'm trying to do a bit of a survey analysis.

Anyways in counting responses this is what i need.

I need to run the COUNTIF function for a particular column, but i only
want this function to run IF the column adjacent to it has a particular
value.

something on the lines of

=IF(Data!C6="Peach",COUNTIF(Data!E:E,"6"),"0")

though this doesn't work... any suggestions???

 

[aidan.heritage]

Sounds like an array formula to me

=sum(IF(C6:C600="Peach",IF(E6:E600,"6",1,0)))

enter as ctrl shift enter - NOTE that you need to have an actual range
for this to work (hence my C6:C600 instead of just C or C6)

 

[Bob Phillips]

I think you want

=SUMPRODUCT(--(C6:C600="Peach"),--(E6:E600=6))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[addicted]

Hello,

Thanks to the both of you. Couldn't have imagined the response would be
so quick and brilliant.

The SUMPRODUCT array function worked great...Thanks Bob, owe ya a beer
mate. Keep up the good work!

Cheers