averageif from another sheet

Lila De Vera
Lila De Vera ✭✭✭✭✭
edited 09/21/20 in Formulas and Functions

Hi everyone,

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!