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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Help On SUMPRODUCT Formula 2
Countif Function 2
countifs Function not giving desired result with date criteria 2
CountIf previous cell formula 0
Sumproduct not working 5
< > question for multiply cells. 2
Finding the weighted average of text that have been given values 1

Back
Top