Thread: If Formula question Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
  
Posts: 570
Default If Formula question Excel 2003
What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!
Reply With QuoteReply With Quote