COUNTIF(AVERAGE-StDev)

PARK_JY — Fri, 15 Nov 2024 22:22:02 GMT

Hi,

I have a question.

1. I want to get the value in sheet.

ex)COUNT({$<A_FIELD={>=Avg(A_FILED)-StDev(A_FILED)}>} FIELD)

but, an error occurs.

Please let me know how to solve it.

thank you.

Re: COUNTIF(AVERAGE-StDev)

barnabyd — Tue, 15 Nov 2022 20:39:07 GMT

I can see a couple of problems. Have a look at the Primer on Set Analysis by Henric. I think your expression is most similar to this one:

Sum( {$<Date={"<=$(=Max(Date))"}>} Sales)

So that suggests that your expression should be:

Count( {$<A_FIELD={">=$(=Avg(A_FIELD) - StDev(A_FIELD))"}>} FIELD )

(I have assumed that A_FILED should have been A_FIELD)

Cheers, Barnaby.