UNPARSEABLE error

Lisa Mol
Lisa Mol ✭✭
in Smartsheet Basics

I get the UNPARSEABLE error with the following formula:

=SUM(COUNTIF([Data1:Data18], ">="&TEXT(AVERAGE([Data1:Data18]),"0.00"))*(([Data1:Data18]>=AVERAGE([Data1:Data18]))))

What am I doing wrong?

· Share on FacebookShare on Twitter

Answers

  • NickStaffordPM
    NickStaffordPM Community Champion

    So there are a couple synthax errors here:

    • You have an extra bracket on the end
    • You are summing the product (*) of a COUNTIF and (([Data1:Data18]>=AVERAGE([Data1:Data18])), I have never used SUM this way so I am not sure if the SUM formula would intrepret this correctly.

    Give these a look and let me know if it doesn't help!

    · Share on FacebookShare on Twitter

Categories

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video<