Excel Formula Error
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.