In , Mike Mike
spake thusly:

This is what I got:
bananas 5 9 3 1
bananas 1 2 7 3
bananas 8 7 4 2
oranges 1 5 1 3
oranges 2 4 8 2
pears 9 5 2 3
pears 7 5 2 3 etc......

I need one row with the totals for each "fruit"

bananas 14 18 14 6
oranges 3 9 9 5
pears 16 10 4 6 etc...

Assuming you're starting in Col A with the names
and data begins on the first row, then -- in
B14, where you have the first "bananas" total,
use this:

=SUMIF($A1:$A7,OFFSET($A$1,ROW()-1,0),B1:B7)

Drag that down and across. This also assumes you
are repeating the names in Col. A on your totals
rows, as you have done in the example.

-dman-