How To Sum Values By Group In Excel

[Fredbugatti]

Hey,
I need a formula to sum up by duplicate names, please see example excel sheet- For example there is apple summing up to 300, so result is each apple gets 300.
See attached for example.

[maniacb]

Try this formula in F2:F4

=SUMIFS(B$2:B$4,A$2:A$4,E2)

[Fredbugatti]

When I drag down formula it does not work.

[Fredbugatti]

Please disregard, it works Thanks!! How can I do it for Averaging numbers?

[Fredbugatti]

Hey, How do I let it sum the quantities and ignore any #N/A

[Haluk]

For the sum of values, ignoring errors; enter this in cell F2 and drag down:

Please Login or Register  to view this content.

For the average of values, ignoring errors; enter this in cell G2 and drag down:

Please Login or Register  to view this content.