Sum rows in column with specific text IF corresponding row in different column has specific text

Question

I have an Excel spreadsheet like this:

     A       B       C
1  CLD     TEXT   Valid
2  CLD     TEXT   Expired
3  CLA     TEXT   Valid
4  CLA     TEXT   Expired
5  CPI     TEXT   Valid
6  CLD     TEXT   Valid

I would like to count the number of rows in column A that have the same text (e.g. CLD) where the text for the same row in column C = Valid and display that counted value elsewhere in the spreadsheet.

Given the data above, I would expect a count of CLD in column A to return a value of 2, as there are only two CLD rows with corresponding Valid in column C.

Matt_Roberts · Accepted Answer · 2014-01-17 17:14:17Z

1

I think that you would be looking for something like this:

=COUNTIFS(C:C,"Valid",A:A,"CLD")

It should count instances based in multiple criteria (in this case just the two).

answered Jan 17, 2014 at 17:14

Matt_Roberts

4441 gold badge7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sum rows in column with specific text IF corresponding row in different column has specific text

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related