Using Visual Basic to pull data from within a range to use in an Excel function

Question

Consider a table or range with three columns for the entire year 2022: date, day of the week, and sales. I need to be able to figure out how much money is typically sold on a Monday, Tuesday, etc. How would I input sales data for each Monday in 2022 into the Average() function using Visual Basic?

Answer 1

Use AVERAGEIFS instead of the full range. I hope this helps you.