I want to create a subtotal for all items with a status of "not cleared" when
the region is East.

My columns are set up so the Region column is A, my total value column is Q
and my status column is U

The team has helped me a great deal providing me with this formula:

=SUMIF(U3:U3000,"<cleared",Q3:Q3000)
which subtotals cleared items, but now that i have created a summary tab, I
wanted to include the Region variable.

How do I add another variable to this equation?

Thanks!!!