Thread: how to count a column based on condition of another column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
R Khoshravan R Khoshravan is offline
external usenet poster
  
Posts: 1
Default how to count a column based on condition of another column
Column E: class of doctors. Includes A,B,C
Column L: residing city of doctors

I want to count number of doctors with class A in a specified city.
I thought the following formula will work:
IF(L10:L93="Tabriz",COUNTIF(E10:E93,"A"),) but it didn't.
Basically I am looking for a foormula to count a cloumn when a condition is
met in another column.
How can I write this formula?
Reply With QuoteReply With Quote