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

Theresa Bruns

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

Brent Wilson

@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 Wilson

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

Theresa Bruns

Thank you!