View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dabnat dabnat is offline
external usenet poster
 
Posts: 2
Default Count based on two different criteria

Sheet name Active
column C has names of counties example: marion
column H has the way something sold example: estate sale

I need a count where column C1-C10000 = marion AND H1 - H10000 = estate sale

How do you create a formula based on 2 requirements that have to be true to
be counted?