searching and combining same value

[kayza]

Hi excel master
I need help solving cases looking for and combining and also sum the same data from my sales report.

and here is my sample data
[table="width: 200, class: grid, align: left"]
[tr]
[td][/td]
[td]A[/td]
[td]B[/td]
[td]C[/td]
[td]D[/td]
[td]E[/td]
[td]F[/td]
[td]G[/td]
[/tr]
[tr]
[td]1[/td]
[td]apple[/td]
[td]manggo[/td]
[td]banana[/td]
[td]orange[/td]
[td]apple[/td]
[td]apple[/td]
[td]banana[/td]
[/tr]
[tr]
[td]2[/td]
[td]orange[/td]
[td]peach[/td]
[td][/td]
[td]apple[/td]
[td]peach[/td]
[td]banana[/td]
[td]apple[/td]
[/tr]
[tr]
[td]3[/td]
[td][/td]
[td]apple[/td]
[td][/td]
[td]banana[/td]
[td][/td]
[td][/td]
[td]peach[/td]
[/tr]
[tr]
[td]4[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td]orange[/td]
[/tr]
[tr]
[td]5[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[/table]

and here is the result I want to get
[table="width: 200, class: grid, align: left"]
[tr]
[td]J[/td]
[td]K[/td]
[td]L[/td]
[/tr]
[tr]
[td][/td]
[td]apple[/td]
[td]6[/td]
[/tr]
[tr]
[td][/td]
[td]banana[/td]
[td]4[/td]
[/tr]
[tr]
[td][/td]
[td]manggo[/td]
[td]1[/td]
[/tr]
[tr]
[td][/td]
[td]orange[/td]
[td]3[/td]
[/tr]
[tr]
[td][/td]
[td]peach[/td]
[td]3[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[/table]



any help would be appreciated

thanks in advance

 

[Joe4]

Just use a simple COUNTIF.
So, if "apple" is in cell K1 and you want to return the count of "apple" in L1, enter this formula in L1:

=COUNTIF($A$1:$G$5,K1)

and copy the formula down for your other values.