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