Hi.

I can't get this formula right. I have two columns of data. Column A is a date, Column B is a number. I want to a formula that will go through column A and check if the date is a Monday AND Column B is greater than 7 and return how many times this occurs.

This is what I have and it does not work.

=COUNTIFS(A:A,"ddd"="sun",B:B,">7")

What am I missing?