It looks difficult but I guess there is a formula to deal my problem:
I got a table with 3 columns.
Lets say column 1 how much hours I worked in specific day, column 2 how many costumers I served, and column 3 how much income I made.


At the top of the chart I make a Statistic formula that tells me averages, for example: how much costumers I serve in 1 hour, or how much the incomes for 1 hours, or how much is the income for 1 costumer.
So I use the COUNT formula to know the number I need to devide the sums, but what happens if I want to deal only with the last 8 lines in the table ? how can I tell the formula to check the last 8 lines which I don't know what are they, since the table gets more and more lines all the time ? is it possible ?

Hi
supposing all your values are contiguous and of course numbers, the following will give the sum of the last 8 cells The part after the SUM function defines a range comprising the 8 last values.In fact many XL users forget that INDEX returns a reference to a cell when used in another formula. That is what we are taking advantage of here

If you have any other requirements perhaps post a sample sheet on the forum please . Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

ain't working.
I attached here a file as an example for what I need
Thanks a lot.

Attached Files

chart.xls (32.0 KB, 12 views)

Ok. I did it. I find another way.

Glad you found a solution. In the future instead of " ain't working" it would be the least to explain what is not working.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post