Count with word

[jusho]

Hay all,

if i have a series of data like this

apple 1
apple orange 5
orange 6

i wanna make a formula or macro that can count by series. Example in others tab i have series

apple
range

i want the result for count
apple 2
orange 1

the orange count only 1 because the 'apple orange' is already cout by apple, i dont want its count again.

and also i want sum function that not repeated

apple. 6
orange. 6

sorry my bad english. Tx before.

 

[MARK858]

Use another column to extract the first word and than do the sums based on that.

Excel Workbook
	A	B	C
1	apple	1	apple
2	apple orange	5	apple
3	orange	6	orange
4
5
6
7		Count	Sum
8	apple	2	6
9	orange	1	6
Sheet1