Hi,

I want a count of two columns meeting a certain criteria. Below is the example of what I want:

A B
Surrender termination
Surrender payment
Surrender confirmation
Maturity termination
Maturity payment
Maturity confirmation
Surrender payment
Surrender payment
Maturity o/s letter


Surrender =5
Maturity =4

I want a formula to count the number of times any of the text from Column B (termination, payment, confirmation and o/s letter) comes with Surrender (Column A) and give the count =5 as above and same with Maturity.

I also want to know if I can do this using sumproduct and will it work in all the version of MS EXCEl.

This is actually a COUNTIF() formula.

=COUNTIF(A:A,"Surrender")

Or if the word Surrender is in a cell next to this formula, you could use:

=COUNTIF(A:A, B12)