UNPARSEABLE error

Lisa Mol

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?

NickStaffordPM

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!