data summary & macros

A

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
 
J

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top