AVERAGEIF

Joerg Schmidt

Hallo,

unfortunately the result shows "#unparseable". Where is my fault? ;-(

=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; >1; <=50000)

Andrée Starå

Hi Jörg,

Try this.

=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; >1)

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

To include the less than criteria, it would look something like this...

=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; AND(@cell > 1; @cell <= 50000))

Andrée Starå

@Paul Newcome I missed that part. Nice catch! Thanks!

Paul Newcome

@Andrée Starå No worries!

Joerg Schmidt

Dear Paul, dear Andrée,

sorry guys, but unfortunately both formula don´t work.

I tried =AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]195; >1; >1 <= 30000) but this is "INVALID" as well ;-((

Another idea ?

Paul Newcome

What error do you receive from this?

=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; AND(@cell > 1; @cell <= 50000))

Andrée Starå

@Jörg Schmidt Novum Hospitality

Strange! I'm with Paul, what error do you get with the formulas?

Joerg Schmidt

#Invalid operation

Andrée Starå

@Jörg Schmidt Novum Hospitality Can you paste the two formulas you've tried?

Info about the error:

https://help.smartsheet.com/articles/2476176-formula-error-messages?_ga=2.163823034.487922610.1554120052-1302373248.1552411124#invalidoperation

Joerg Schmidt

sorry guys,

the fault was as always sitting in front of the computer - me ;-(

I found my fault - a failure in one formula in one row leads to the #invalid operation.

It´s solved now. Your solution was perfect. Thank you ;-))😁

Andrée Starå

@Jörg Schmidt Novum Hospitality

Excellent!

Glad you got it working!

✅Remember! Did mine or someone else post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Happy to help! 👍️