View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott Stedman Scott Stedman is offline
external usenet poster
 
Posts: 3
Default Countif using two columns?

I have a list of oil and gas wells by county and status. For example:

County Status
SEWARD SI
SEWARD Active
STEVENS Active
STEVENS SI
HASKELL Active
HASKELL SI
HASKELL Active

I want can easily use COUNITF to show that I have three SI (shut in)
wells and four active wells but I want to expand that data to show how
many SI and Active wells I have in each county. Is this possible?