Looking to create function that counts rows only when 2 conditions are met from different rows

Options

I have two rows in question, one containing a list of states, the other containing a list of "types". I am looking to create a function that only counts rows that satisfy 2 specific criteria. For example, only count rows that contain State = Colorado AND type = payment.

To make things more complicated I am referencing the columns from another sheet.


Any help is greatly appreciated.

Answers

  • Lidiya S.
    Lidiya S. ✭✭✭
    Options

    James,

    You can use the COUNTIFS function!

    For example: =COUNTIFS(State:State,="Colorado",Type:Type.="payment")

    You would use the "Reference Another Sheet" function but make sure you only select the State column in the other sheet for the first reference. And only the Type column for the second reference.

    Hope this works out for you!

    Best,

    Lidiya Shutaya

    lidiya@ddbconsultants.ca

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!