I have a formula which is like this
=COUNTIFS('sheet1 '!W:W,">0",'sheet1 '!A:A,"Truck")
which is count all data in column W (sheet1) larger than 0, which are called Truck in column A.
Now, I want this formula to read the same information but by consider a range of dates in between 1st of October to 15th (I have dates in Column B).
Any input is greatly appreciate.