countif formula using named cells

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")
 
G

Glenn

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)
 
T

teresa

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