filter date bounded between two ranges

Question

I am using google sheetsHow to use the filter function to filter date bounded between two ranges and sum horizontally these values, see attached file.

dscheikey · Answer

ajl_ahmed&nbsp;You can achieve multiple filter criteria as AND() by adding and OR() by multiplying.In your case:&nbsp;=FILTER(B7:J12,((B7:J7&gt;=D6)+(B7:J7&lt;=G6)&gt;1))&nbsp;

hansvogelaar · Answer

ajl_ahmed&nbsp;
To filter the data, you can use the formula
&nbsp;
=FILTER(B7:J12,B7:J7&gt;=D6,B7:J7&lt;=G6)
&nbsp;
I wouldn't place SUM formulas to the right of the output range since the width of the output is variable.

ajl_ahmed · Answer

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&nbsp;

ajl_ahmed · Answer

Same Problem I have when applying on Google Sheet.

ajl_ahmed · Answer

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

Forum Discussion

filter date bounded between two ranges

6 Replies

Resources