tonguencheek
Board Regular
- Joined
- Apr 6, 2010
- Messages
- 233
Let's say I have a column of data and I want to find the average based on the number of periods which can be manually inputted in cell A1.
The column of data starts in C1 and the formula will be entered in A2.
As an example, if the user enters "10" in A1, then it will average (a1:a10). If they enter 50 it would average (a1:a50) etc.
Any help would be great.
Also, how can you make it so that excel DOESN'T ignore blank cells when computing and average?
The column of data starts in C1 and the formula will be entered in A2.
As an example, if the user enters "10" in A1, then it will average (a1:a10). If they enter 50 it would average (a1:a50) etc.
Any help would be great.
Also, how can you make it so that excel DOESN'T ignore blank cells when computing and average?