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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =COUNTIF([Listing Key]2:[Listing Key]20, "BofA")

     

    Give this a shot...

    thinkspi.com

  • J. Craig Williams
    J. Craig Williams Top Contributor

    That doesn't quite do it.

    FREQUENCY() in Excel does not have a true counterpart in Smartsheet. 

    You'll need to build this functionality yourself using COUNTIF() as Paul lists, but each search term ("BofA") needs to be set up in turn. In other words, somewhere that you can build your own table to get them.

    Craig

     

    SmSh_Frequency.png

  • IamRachal
    IamRachal ✭✭✭✭✭✭
    edited 08/17/18

    I appreciate the suggestion! Thank you.

  • IamRachal
    IamRachal ✭✭✭✭✭✭

    I'll try this with more criteria to get the formulas to work. Thank you, Craig!