Combine COUNTIFS with a date and row criterea

Options

I have two formulas working independantly and now I am trying to combine the critera but I am not sure which formula to use.

Working formulas are:

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "A (South king cty)")

Basically I want to look in one row for a criteria (range 2) and then look in another row for a date range (range 1).

Maybe: =COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "D (north seattle/king cty)", AND(COUNTIF({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))))


Help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!