View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default countif formula using named cells

Thanks so much! I don't know why I didn't see my mistake, but you sure
helped me out.

"Glenn" wrote:

teresa wrote:
What should the syntax be for using a named cell in a countif formula? I've
been trying this, but it's not working. BOM is my named cell.

=COUNTIF(D12:D130,"=BOM")



=COUNTIF(D12:D130,"="&BOM)