The law of averages ???

[Jimmy110]

Hi,

Could anyone help me with a little problem?? I have a column with weight data from 3 different target ranges....10kgs / 12kgs / 15kgs.

Currently I'm having to work out the average by selecting all the relevant 10kgs weights (Could be as low as 9.7 or as high as 10.9) and look at the info bar at the bottom, then repeat for all the 12kgs weights, (again, looking for any measurement that's from about 11.7 to 12.9) then finally the same for the 15kg range.

Is there a formula that would do it for me to save time?

I've added an example file.... weight data is in column A, my manually calculated averages are just typed into cells C2, C3 & C4..... but could they contain a formula to return those values automatically?

(something to point out, is not all of the weight ranges are grouped together....for example the 15kgs data starts at A47-A54, then more appears at A143, to the end of the data)

Exacmpe Data File.xlsx

1drv.ms

Any help appreciated.....

Cheers

James

 

[FormR]

all the relevant 10kgs weights (Could be as low as 9.7 or as high as 10.9)

You could try AVERAGEIFS() - for example:

=AVERAGEIFS(A:A,A:A,">=9.7",A:A,"<=10.9")

 

[Jimmy110]

perfect! That works a treat....thank you so much for helping....its saved me loads of time!