Forum Discussion
filter date bounded between two ranges
I am using google sheets How to use the filter function to filter date bounded between two ranges and sum horizontally these values, see attached file.
Thx. for your replyI have applied it to my work on Google Sheets but it didn't expand dynamically to display all values of cells between the start and end datedscheikey
The syntax in Excel and in Google Sheets differs for the filter function.
Excel: =FILTER(array,include,[if_empty])
Google: =FILTER(array, Condition1, [Condition2, …])
The formula I wrote for Excel also works in Google Sheets. But there (but also only in Sheets) you could also write more simply:
=FILTER(B7:J12,B7:J7>=D6,B7:J7<=G6)
Just as HansVogelaar has already suggested.