Counting a value that appears within a row

Richard C

I am building an inventory sheet for a nonprofit board and identified a number of criteria the board governance committee will need to track.  I've created various demographic columns such as age, ethnicity, residence, etc.  The formula below has worked for all the columns created so far but getting "unparseable" error.  I've checked the column property heading to make sure I have it right and I do.  Here is the formula that I'm trying to use.

=COUNTIF(Current Term Expire5, "2017")

Again, it is the same I've used for other columns which are working:

=COUNTIF(Age5, "45-64")

=COUNTIF(Ethnicity5, "Hispanic/Latino")

It appears where the formula works--the column header is highlighted and the header isn't highlighted in the cell that turns into unparseable.

Appreciate anyone helping out. 

Thanks.

 

 

Shaine Greenwood

Hello Richard,

To reference column names that contain spaces, enclose them in square brackets like in the example below:

=COUNTIF([Current Term Expire]5,"2017")

The formatting is [COLUMN NAME]#

There are a few other tricks that you can pick up from the Create and Edit Formulas help article: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet