# 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!

• ✭✭✭✭✭✭
Options

Try this:

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "A (South king cty)", {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))

• ✭✭✭
Options

Thanks Paul! I had a corworker help me with my issue, I had a range selected instead of a row when I first wrote the formual (first section) so when combining them it did't work. Thanks for the response!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!