data summary & macros

[Anthony]

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

 

[Jacob Skaria]

Do you mean the totals for each type...

In Col D if you have the animal types

cow
bull

In Col E use the below formula
=SUMIF(A:A,D1,B:B)
and in Col F use the below formula
=SUMIF(A:A,D1,C:C)

 

[Jacob Skaria]

Oops...Please ignore the below post.....

 

[Patrick Molloy]

a pivot table will do this for you