WalOne

10-09-2009, 05:28 PM

Specifically, where I need an average of two or more cells that are themselves averages. I'm using the average function to arrive at averages for some individual cells OK, e.g. if formatting at cell a6 is =average(a1..a5), cell a16 is =average(a10-a15), the answers are correct. But if I then format a different cell with =average(a6+a16), all I get is the sum of the values, and have to insert in this case, /2 in order to show the correct figure.

I can do a convoluted calculation that will add the totals, divide that using the count function, but the idea is to produce a spreadsheet that is robust from the standpoint that individual formulae do not need adjusting to suit changing criteria.

I must be missing something here: anybody any ideas?

I can do a convoluted calculation that will add the totals, divide that using the count function, but the idea is to produce a spreadsheet that is robust from the standpoint that individual formulae do not need adjusting to suit changing criteria.

I must be missing something here: anybody any ideas?