countif formula using named cells

  • Thread starter Thread starter teresa
  • Start date Start date
T

teresa

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")
 
teresa said:
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")
Click to expand...


=COUNTIF(D12:D130,">="&BOM)
 
Back
Top