Hi,
I need to do an average of multiple days in an extension of Averageifs formula. How do i go about selecting the multiple days.
Example:
Data has line items with Days mentioned in 1 of the columns.
I need to get an average of (Mon-Thu, Mon-Tue, Sat-Sun) in the output sheet ... Kindly assist
The current formula is
=AVERAGEIFS(Sheet1!$I$2:$I$14440,Sheet1!$J$2:$J$14440,">="&Sheet3!E6,Sheet1!$K$2:$K$14440,"<"&Sheet3!F6,Sheet1!$D$2:$D$14440,"=????what do i mention here to get the average of desired day????????")
Bookmarks