filter date bounded between two ranges

[ajl_ahmed]

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.

[#2]

@ajl_ahmed 

You can achieve multiple filter criteria as AND() by adding and OR() by multiplying.

In your case:

=FILTER(B7:J12,((B7:J7>=D6)+(B7:J7<=G6)>1))

[#3]

@ajl_ahmed 

To filter the data, you can use the formula

=FILTER(B7:J12,B7:J7>=D6,B7:J7<=G6)

I wouldn't place SUM formulas to the right of the output range since the width of the output is variable.

[#4]

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 date@dscheikey 

[#5]

Same Problem I have when applying on Google Sheet.

[#6]

Same Problem I have when applying on Google Sheets. Just displaying the dates without underlying cells values

[#7]

@ajl_ahmed 

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 @Hans Vogelaar has already suggested.