You have data on daily sales for a major grocery store for an entire year. Column A contains the daily sales total in dollars. Column B contains the date, and Column C contains the day of the week: If you want to use the AVERAGEIFS() function to take an average of daily sales conditional on the day of the week being Thursday, which formula below uses the correct syntax? =AVERAGEIFS(A2:A366, C2:C366, 4) =AVERAGEIFS(B2:B366, A2:A366, "Thursday") =AVERAGEIFS(A2:A366, B2:B366, "Thursday") =AVERAGEIFS(A2:A366, C2:C366, "Thursday")