Calculating pace

[Donny]

Hi,
I would like help in creating a formula to get a pace
(average) for productivity from the last 10 days from
today.

My data is:
P32000 are numbers for amount done.(There are blank
cells if work has not been done yet)

AC3:AC2000 are dates work was done in (there are blank
cells if work has not been done yet) AC is not sorted!


TIA

 

[Peo Sjoblom]

Try this array formula

=SUM((AC3:AC2000=TRANSPOSE(LARGE(AC3:AC2000,ROW(INDIRECT("1:10")))))*(P320
00))/10

entered with ctrl + shift & enter

it has nothing to do with today's date but it simply sums the values in P
where AC holds the last 10 dates and divides by 10

 

[Donny]

Thank you very much!

-----Original Message-----
Try this array formula

=SUM((AC3:AC2000=TRANSPOSE(LARGE(AC3:AC2000,ROW(INDIRECT ("1:10")))))*(P320
00))/10

entered with ctrl + shift & enter

it has nothing to do with today's date but it simply sums the values in P
where AC holds the last 10 dates and divides by 10

--

Regards,

Peo Sjoblom





.