Sheet Summary AVGIF
I am trying to do a sheet summary using two columns. My first column is Audit Month which contains a month (January, February, . . .). The second is a score that I would like the average of but only for a particular month. Below is what I thought would work.
=AVG([Audit Score]:[Audit Score]), IF(CONTAINS([Audit Month2]:[Audit Month2], “January”))
I will also need to do this for each week.
Answers
-
@Joey135 Try this
=AVERAGEIF([Audit Month2]:[Audit Month2], “January”,[Audit Score]:[Audit Score])
-
@JamesB That did work. Thanks so much.
-
Hi @Joey135
I hope you're well and safe!
Try this. (I think @JamesB wrote the formula in Word or similar and got the leaning ““ instead of "")
=AVERAGEIF([Audit Month2]:[Audit Month2], "January",[Audit Score]:[Audit Score])
Did that work?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Thanks for catching that. I wrote it from an Android device. I will be more cognizant of that in the future.
-
Happy to help! Easy to miss!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | 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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!