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.