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
Asked
Active
Viewed 78 times
0
Ron Rosenfeld
- 8,198
- 3
- 13
- 17
Stephanie Young
- 1
- 2
-
DATE RECEIVED CELL N – Stephanie Young Jul 20 '21 at 12:18
-
DAYS TAKEN TO SEND TO THE COLLEGE CELL S – Stephanie Young Jul 20 '21 at 12:18
-
1Use AVERAGEIF to do this – PeterH Jul 20 '21 at 12:26
-
@PeterH i have tried but i carnt get the formula to work – Stephanie Young Jul 20 '21 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. – PeterH Jul 20 '21 at 12:29
-
@PeterH - i have attached a picture to the post, i want to work out the average days taken to send to college but for date received after 17/05/2021 – Stephanie Young Jul 20 '21 at 12:42
-
SUMIF and COUNTIF functions? – Lee Jul 21 '21 at 09:06
1 Answers
0
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.
Gary's Student
- 19,266
- 6
- 25
- 39