counting number of times a word appears in column A dependent on Column B

Theresa Bruns
Theresa Bruns ✭✭
edited 07/25/22 in Formulas and Functions

How can I count how many times the word "Paid" appears in Column A when Column B says "invoiced" on the same row?

Best Answer

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Answer ✓

    @Theresa Bruns

    =COUNTIFS([Column A]:[Column A], ="Paid", [Column B]:[Column B], ="Invoiced")

    The COUNTIF works like an "AND" statement so "Paid" AND "Invoiced"

    So if it Has "Paid" and "Credited" it will not be counted..

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!