Major Excel Formula Needed

[Pulse]

I need help with creating a formula that selects a certain value in one column then reads across and then selects only the ones that also fit another criteria.

for instance if i have a column of fruits in stock i want it to select, say, apples. Then i want it to select how many are red from another column, so it fills 2 criteria, apple and red. and then returns the value of how many do apply to both.

is this even possible?

 

[Pulse]

and how would i go about doing that? dont have to make it too detailed.

 

[Pulse]

cheers anyway

 

[Pulse]

{=SUM(IF(H2:H121="Apple",IF(I2:I121="Red",1,0)))}

i can understand this and i would think that it should work but it doesn't,

i'll try and give it in its rightful context.

In column C i have law areas and i want it to select "Contact" then i want it to look and see if a name was supplied on a form (this is in another column (P) with 1 denoting a Yes and a 2 denoting a No) all of this is on a different sheet.

so i would think to use the code
=SUM(IF('Data Entry Sheet'!C:C="Contact",IF('Data Entry Sheet'!P="1",1,0)))

or have i already gone wrong? i dont get what is with the wierd brackets in your example