simple array sum

Sheet1

100
apple
4
200
apple
3
200
banana
2
300
banana
1
Sum:
#VALUE!

Sheet2

Sheet3