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???


--
addicted
------------------------------------------------------------------------
addicted's Profile: http://www.excelforum.com/member.php...o&userid=34658
View this thread: http://www.excelforum.com/showthread...hreadid=544240

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)

I think you want

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"addicted" wrote in
message ...

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???


--
addicted
------------------------------------------------------------------------
addicted's Profile:
http://www.excelforum.com/member.php...o&userid=34658
View this thread: http://www.excelforum.com/showthread...hreadid=544240

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


--
addicted
------------------------------------------------------------------------
addicted's Profile: http://www.excelforum.com/member.php...o&userid=34658
View this thread: http://www.excelforum.com/showthread...hreadid=544240