a pivot table will do this for you

"Anthony" wrote in message
...
Hi

once again my needs are outstripped by my abilities so I turn here for
help

I produce weight reports from my scales for cattle weighed by type and
number

Each weighing event is made up of multiple weighings specifying type,
number
and weight.

This is exported in excel format as below.

I need the formula to present a summary at base that does the following
Look at animal types listed and dop the "names" into the summary area, and
then sum the total number oif animals for that type plus there weight into
cells along side


A B C
Cow 22 10000
Cow 5 3200
Steer 3 1780
Bull 1 450
Steer 17 5600
Cow 2 890

The summary needs to pull the animal types as above with toatls per type.

BNext time I weigh the animal types may well be different.

Once I have formulas correct I wll record macro to fast track

Hopefully this q makes sense

anthony