Google Sheets Query with multiple and or statements

Named Ranges
dates=”Addition Archive”!D:D
archive=”Addition Archive”!B3:BC
ingredient = C3
start = D3
end = E3

Formula to filter data by date

=FILTER(archive, dates>=start, dates<=end)

That will give you an array of your data filtered for your date range. Depending what you are trying to do next you can do it to that array.

You may Also Like:

None found

Leave a Comment