I have a list of projects. the row has the region and the project name. I have the start date of the project and the end date. I have a calculated field giving me the number of days it took to complete the project. There are a lot of projects that are missing dates so I filtered those out (start and end dates), removing the nulls. I am trying to get an average for the region of the total number projects, but only the ones that have the number of days calculated. Any suggestions on how to accomplish this? I know it sounds simple but for some reason I am not able to figure it out. Thanks
It's a bit difficult to help without actually seeing a sample workbook. Assuming you calculated the number of days in a field called [Number of Days], why wouldn't AVG([Number of Days]) work? Any row with [Number of Days] = null would be excluded from your average.