Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating pace
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: P3:P2000 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 |
#2
|
|||
|
|||
Try this array formula
=SUM((AC3:AC2000=TRANSPOSE(LARGE(AC3:AC2000,ROW(IN DIRECT("1:10")))))*(P3:P20 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 "Donny" wrote in message ... 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: P3:P2000 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 |
#3
|
|||
|
|||
Thank you very much!
-----Original Message----- Try this array formula =SUM((AC3:AC2000=TRANSPOSE(LARGE(AC3:AC2000,ROW(I NDIRECT ("1:10")))))*(P3:P20 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 "Donny" wrote in message ... 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: P3:P2000 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Calculating Cells - Slower in Smaller File | Excel Discussion (Misc queries) | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Periodic Calculating | Excel Worksheet Functions |