Thread: countif formula using named cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default countif formula using named cells
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)
Reply With QuoteReply With Quote