Forum Discussion
Counting within columns
apple banana peach apple apple orange grapes apple banana orange apple peach apple apple grapes banana banana apple For a chart like the abo...
As variant for such layout
it could be
=SUM( --( MMULT( (E2=$A$1:$C$8) + (F2=$A$1:$C$8), {1;1;1} ) > 1) )