Average Monthly Report Excel

Asked Jun 25 '20 at 18:02

Active Jun 25 '20 at 18:05

Viewed 36 times

I am trying to get the average time it takes to complete a project. The excel sheet is constantly being updated. I used =AVERAGEIFS(L:L,D:D,">="&$O2,D:D,"<="&EOMONTH($O2,0)) which gives me you can't divide by 0 and I tried pivot tables and they are not working because I need the grand average. Attach is a photo of my spreadsheet.

edited Jun 25 '20 at 18:05

BigBen

46,229
7
24
40

asked Jun 25 '20 at 18:02

svjeller

1

Does `O2` have a date in it, or just the text `Jul`? You need an actual date. – BigBen Jun 25 '20 at 18:05
1

Make sure `=EOMONTH($O2,0)` returns what you think it should – Scott Craner Jun 25 '20 at 18:13
Try `EOMONTH("1 "&$O2,0)` – Scott Craner Jun 25 '20 at 18:22

Average Monthly Report Excel

0 Answers0