vlookup - Using Dates with VLookup and Countifs
问题描述
First time posting here.
I've been trying to filter for "Accepted" Deals in one column against "Sat Date" in another column.
I've been able to filter for the results I want individually but have struggled to find a way to combine them.
So far they look like this.
=COUNTIFS(M1:M45, VLOOKUP("Accepted", M1:M45, 1, False)) for the one column.
=COUNTIFS(L2:L45,">=01/01/2021", L2:L45,"<=04/03/2021")
Not entirely sure what I'm doing wrong and struggling to find a solution online.