Multiple Values Corresponding Cells with Blank Entries Between

If what NBVC said is what you're aiming for, you could do the following:

These formulas/values are specified to go starting in column AA for typing simplicity here. Alternatively, you can slide things down and put it on the top (recommended).
AA2: apples
AA3: oranges
AA4: ...
[all fruits in the column]

AB1: Y
AC1: N

PHP Code: 

AB2: =SUMPRODUCT(--($A$2:$A$150=$AA2),($C$2:$C$150=AB$1)+($G$2:$G$150=AB$1)+($K$2:$K$150=AB$1)+($O$2:$O$150=AB$1)) 


Drag the formula in AB2 down for all the fruits and across. It should give you the full totals for them all.

S