Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021.
can anyone help
-
DATE RECEIVED CELL N– Stephanie YoungCommented Jul 20, 2021 at 12:18
-
DAYS TAKEN TO SEND TO THE COLLEGE CELL S– Stephanie YoungCommented Jul 20, 2021 at 12:18
-
1Use AVERAGEIF to do this– PeterHCommented Jul 20, 2021 at 12:26
-
@PeterH i have tried but i carnt get the formula to work– Stephanie YoungCommented Jul 20, 2021 at 12:28
-
your question doesn't make it easy to provide you with answer, re write it show exactly what you ahve and what you want it to look like using sample data etc.– PeterHCommented Jul 20, 2021 at 12:29
|
Show 2 more comments
1 Answer
With dates in A1 through A10 and take in B1 to B10, Pick a cell and enter:
=SUMPRODUCT(--(A1:A10>=DATE(2021,5,17)),B1:B10)/SUMPRODUCT(--(A1:A10>=DATE(2021,5,17)))
With Excel365 you could use the FILTER() function.
answered Jul 20, 2021 at 12:34
