=SUMPRODUCT((A1:A15="Ghana")*(B1:B15="Invalidate") )

Alan Beban

Jennifer wrote:
I am trying to write a formula that tells me how many from
Ghana were Invalidated (Answer=4)

In other words, count column A only if it is "Ghana", and
only if column B is also "invalidate"

Column A Column B
Brazil Validate
Bulgaria Invalidate
Bulgaria Invalidate
Bulgaria Invalidate
Bulgaria Invalidate
Bulgaria Validate
Bulgaria Invalidate
Bulgaria Validate
Ghana Invalidate
Ghana Invalidate
Ghana Invalidate
Ghana Invalidate
Ghana Validate
Greece Validate
Greece Invalidate

Thank you in advance for any help or advice!

Jennifer