View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jennifer[_6_] Jennifer[_6_] is offline
external usenet poster
 
Posts: 1
Default Request for Help with Count Formula

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