Sunday 11 February 2018

google spreadsheets - Countifs by consider dates range

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. Thanks

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...