I am looking to add a date range selector to a formula and despite looking at other examples, I cannot get it to work.
In B6 of the output sheet, I would like to only return the values from the data where the dates are in a range. Sheet 'Form responses 1' holds the data in column A for the date.
The range is input by the user in B1 & B2
Thank you in advance. BVG
Last edited by Badvgood; 02-20-2020 at 03:37 PM.
I've used below formula from B6:F9 cells
=COUNTIFS('Form responses 1'!$B:$B,B$5,'Form responses 1'!$E:$E,$A6,'Form responses 1'!$I:$I,$A$4,'Form responses 1'!$L:$L,">="&$B$1,'Form responses 1'!$L:$L,"<="&$B$2)
Hope it helped you!!
Thank you so much, it worked perfectly. Kind regards BVGOriginally Posted by Naren_Kumar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks