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 currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…
Hi all. I am working with a sheet trying to get what - I thought - would be a simple average, but the formula seems to be returning the incorrect value. I am trying to get an average of the temperature in a column if the created date (created date is the Smartsheet default column) is equal to yesterday: Which I would…
