Auto Sum, MAX and Min

G

graydon

Hi
I have absolutely massive spreadsheets based on horseracing results.
Each selection (horse) has 5 columns of data and anything upto 30 rows each.
I have managed (with help) to collate the info so that at the break between
each selection there are 3 blank rows. What I would like to do with relative
ease is to use these 3 rows under each selection to autofill 'Sum,Max and Min'
Also these cells that become filled I need to be replicated in clear cells
five columns to the right.

I would be grateful if anybody could help this new user.
Thanks
G
 
T

Teethless mama

In A35: =SUM(A$1:A$30)
In A36: =MAX(A$1:A$30)
In A37: =MIN(A$1:A$30)

Select A35:A37 and drag Fill Handle to copy across other columns
 

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

Similar Threads

Combining two formulas 0
Making MAX and MIN range variable 1
MAX() and MIN() 4
array formulas using MIN MAX 3
Conditional Formatting Using Min/Max 10
Filling speadsheet with INDIRECT functions? 2
conditions and the max function 1
Conditional formula using MIN function doesn't work 5

Top