ExcelBanter - countif formula using named cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif formula using named cells (https://www.excelbanter.com/excel-worksheet-functions/244207-countif-formula-using-named-cells.html)

Teresa

countif formula using named cells

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

Glenn

countif formula using named cells

teresa wrote:
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")

=COUNTIF(D12:D130,"="&BOM)

Sean Timmons

countif formula using named cells

=COUNTIF(D12:D130,"="&BOM)

"teresa" wrote:

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

countif formula using named cells

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

"Glenn" wrote:

teresa wrote:
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")

=COUNTIF(D12:D130,"="&BOM)

All times are GMT +1. The time now is 08:20 PM.