Sign in to join the conversation:
Hallo,
unfortunately the result shows "#unparseable". Where is my fault? ;-(
=AVERAGEIF([VS/Zimmer]1:[VS/Zimmer]199; >1; <=50000)
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!
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!
@Andrée Starå No worries!
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?
@Jörg Schmidt Novum Hospitality
Strange! I'm with Paul, what error do you get with the formulas?
#Invalid operation
@Jörg Schmidt Novum Hospitality Can you paste the two formulas you've tried?
Info about the error:
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 ;-))😁
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!
Happy to help! 👍️
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
