In , Dallman Ross <dman@localhost.
spake thusly:

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:

I didn't mean "B14", but rather in the first totals
row (for "bananas") in Col B. When I set up my
test sheet, I had it in B14, but it doesn't matter
which row the totals start on:

=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-