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

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. ✭✭✭

    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!