averageif from another sheet
I have a sheet that is populated from a form. There are several departments listed, and more often than not a department is listed more than once. Within that sheet I have a column listing the response time in days. The response time in days is calculated based on the information within that row.
I have another sheet for statistics that is used to populate my dashboard. I'm trying to calculate the average response time in days per department. I thought the averageif function would work but it's not. I've attached the two columns in question and the formula I'm using at the time. Thanks!
I should note that the current formula displays 0, however, it should be 3.
Help Article Resources
Check out the Formula Handbook template!