Formula to average a range in another sheet corresponding to cells that contain parts of text

I can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0.

I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working with I'm trying to say: If any cell in the Month/Year/Email column contains the words "Q1 2017 Up to Date" then show the average of successful deliveries. I'm working on this in another sheet where I'm referencing each column range.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!