AVERAGEIFS parse error

by Gaurav   Last Updated January 11, 2019 10:03 AM

=AVERAGEIFS(Sheet12!R:R,Sheet12!A:A,N5,Sheet12!B:B,">=9/16/2018",Sheet12!B:B,"<=10/3/2018")

While giving cell range instead of a date value, it's showing error.



Related Questions



Multiple conditions, weighted average in spreadsheet

Updated November 18, 2017 19:03 PM


How to interpolate data in a range in Google Sheets

Updated December 29, 2017 07:03 AM