| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Countif + Named range | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| how do you use named cells in the countif function | Excel Worksheet Functions | |||
Linear Mode
