AVERAGEIF
Hallo,
unfortunately the result shows "#unparseable". Where is my fault? ;-(
=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; >1; <=50000)
Comments
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
To include the less than criteria, it would look something like this...
=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; AND(@cell > 1; @cell <= 50000))
-
@Paul Newcome I missed that part. Nice catch! Thanks!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
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 ?
-
What error do you receive from this?
=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; AND(@cell > 1; @cell <= 50000))
-
@Jörg Schmidt Novum Hospitality
Strange! I'm with Paul, what error do you get with the formulas?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
#Invalid operation
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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 ;-))😁
-
@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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Help Article Resources
Categories
Check out the Formula Handbook template!