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

Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Excel Countif Function - Calculating Between Two Sets of Values 3
countifs Function not giving desired result with date criteria 2
Finding the weighted average of text that have been given values 1
Sumproduct not working 5
COUNTIFS using multiple named ranges in the criteria 0
Countif formula perhaps 8

Top