Countifs by consider dates range [closed]
Solution 1:
If you’re talking about Excel, the formula is
=COUNTIFS(W:W,">0", A:A,"Truck", B:B,">10/1/2017", B:B,"<10/15/2017")
You may want to change the > and < to >= and <=,
depending on whether you want to include Oct 1 and Oct 15
in your “between” range.
Illustration:
Only row 7 is counted.
If you’re talking about Google spreadsheets, the above might also work, but I don’t know.
And, of course,
if you normally write dates as dd/mm/yyyy,
then you should use 1/10/2017 and 15/10/2017.