Excel Formula Error

IamRachal
IamRachal ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

 

I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas:

=COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1))))

The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a screenshot for reference of what I may be doing wrong. 

 

Capture.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!