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.
 

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

Help On SUMPRODUCT Formula 2
CountIf previous cell formula 0
Countif formula perhaps 7
Countif Function 2
Excel Named Ranges and Conditional Format 3
< > question for multiply cells. 2
Formula Problem 2
Finding the weighted average of text that have been given values 1

Top