sum the price

Question

Hi I have a dataset that I have to check with the average price to the column F2

Input:

FruitF2PriceAppleaverage price: 10   15  13Mangoaverage price:12   12Bananaaverage price: 8   10  5  15

Output:

Fruit PriceAppleaverage price: 1014Mangoaverage price: 1212Bananaaverage price: 810

Qiu · Answer

@Sebastiaandb 
Faster does not mean better. :)

Sebastiaandb · Answer

Of course, @Qiu  was faster ;-).

Sebastiaandb · Answer

hI @Sshasnk

Here you go!

AVERAGE.yxmd