Request for Help with Count Formula

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

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
 
Back
Top