Ask Your Question

Where's my mistake-see Upload...

asked 2017-04-18 13:19:54 +0100

abi gravatar image

updated 2017-12-10 17:04:43 +0100

erAck gravatar image

[upload: not work ??] a b c d [1.0 2.0 3.0 0.]... = averageif((a1:d1); (x>=0))

edit retag flag offensive close merge delete


(Converted to an answer.)

Lupp gravatar imageLupp ( 2017-04-18 14:15:42 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-04-18 13:25:52 +0100

robleyd gravatar image
edit flag offensive delete link more

answered 2017-04-18 14:35:33 +0100

Lupp gravatar image

You had the x as a kind of unspecified variable in this recent question of yours, too.

You should either stop to use it, and apply the way to give a criterion I showed you, or, at least, explain precisely for what reason you insist on the x and what it is meant to mean. I read it as "the current element of the range in the first parameter position". The criterion parameter will assume this implicitly. An implicit = is added if no explicit comparator is given.

Did you mean =AVERAGEIF(A1:D1; ">=0")?
Please note: A Criterion parameter is of a very specific kind. You have to compose it as a text (string) despite the fact that it is designed to become the comparator followed by the right hand part of a comparison (either an equation or an inequation). Only the bodies of functions having Criterion parameters can handle comparisons this way.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-18 13:19:54 +0100

Seen: 39 times

Last updated: Apr 18 '17