Excel Formula Error

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.

Find more posts tagged with

Formulas

Real Estate

Marketing

Importing and Exporting

Comments

Paul Newcome

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

Give this a shot...

J. Craig Williams

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

IamRachal

I appreciate the suggestion! Thank you.

IamRachal

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…