Any way to calculate an average for more than 30 entries?

T

torin_drake

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
 
D

Don Guillett

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

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

Month days over a time period 5
Average more than 30 numeric arguments 15
calculate average values for 100 records in the shortest way? 5
Calculate average in intervals 1
Averaging feet and inches (not decimal feet) 4
Problem using average or sum formulas 3
Average of top x% of a list 1
How do I average cells that contain #DIV/01? 2

Top