I want a column of days (Aker BP Data'!B$2:B$1044) (Mon, Tue, Wed etc...) and be able to filter the specific day "*Mon*" first, and then get the average % of another column (Aker BP Data'!I$2:I$1044,")
This is the code I used for some other statistics, but can it be altered with some simple re-coding?
=COUNTIFS('Aker BP Data'!B$2:B$1044,"*Mon*",'Aker BP Data'!I$2:I$1044,">"&B13)
Thank you!
Bookmarks