ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Any way to calculate an average for more than 30 entries? (https://www.excelbanter.com/excel-worksheet-functions/13445-any-way-calculate-average-more-than-30-entries.html)

torin_drake

Any way to calculate an average for more than 30 entries?
 
im trying to calculate the average of blood sugar results, that will require
using more than the 30 numbers that excel limits itself to, any help wqould
be greatly appreciated

Don Guillett

Just how are you trying to do this? Post your formula if this doesn't help
=average(a1:a29999)

--
Don Guillett
SalesAid Software

"torin_drake" wrote in message
...
im trying to calculate the average of blood sugar results, that will

require
using more than the 30 numbers that excel limits itself to, any help

wqould
be greatly appreciated





All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com