Advanced COUNTIFS question

Excel Countif question


Excel Countif question

I want the automated values in ROW 21 to show how much more or less revenue we made that weekday (weekdays in ROW 7). Total revenue a day in ROW 20.

I can’t for the love of God, find anyway to make a slick single formula.

I am as of yet stuck with writing down myself, how many of a specific weekday we’ve been open (as a store) to calculate an AVERAGE  extraced from a COUNTIF function that sums the specific weekdays in the entire sheet.

Please help.

By: TwoMinuteGenius

Leave a Reply

Your email address will not be published. Required fields are marked *