Sheet Summary formula not working

Christina Riot

Any ideas as to why this formula isn't working?

=COUNTIF([Return- boundaries between works areas]:[Return- boundaries between works areas], "Very Important")

I coped the column name from the actual column as to not misspell anything etc. Then I tried typing it out thinking maybe the copy and paste went screwy. Nothing works. No matter what I do i get unparseable.

Kelly Moore

Hi Christina

I copied your formula into a sheet. I copied your column name exactly. I made sure the "Very Important" cell data was exact. Your formula worked perfectly. The column type I put the formula in was a Text/Number column.