Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 24, 2022

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.
excel
Excel for web
dscheikey's avatar
dscheikey
Bronze Contributor
Nov 24, 2022

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))

 

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 24, 2022

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 

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Nov 24, 2022

    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 HansVogelaar has already suggested.

     

     

Resources