Count how many cells are Delta 320
The formula I tried is :
=COUNTIFS(Client:Client, @cell = "Delta", Fleet:Fleet, @cell = "320")
but I got 0.
Answers
-
Hi,
I hope you're well and safe!
Try something like this.
=COUNTIFS(Client:Client, @cell = "Delta", Fleet:Fleet, @cell = 320)
Did that work/help?
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.
-
Yes that worked. If I added the average to the front would it also give me the average number?
-
Excellent!
Happy to help!
An Average formula has to look at numbers. What do you want to get the average of?
✅Remember! 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.
-
So the cell is showing how many events a person worked on the delta 320. the emp_nr is the person. I am trying to find out the average number of delta 320 events per person.
-
Could I do a count distinct formula in the emp_nbr column that are on Delta 220? then just enter the value in a cell with the total number of events to get the average?
-
You can get the number of employees with this:
=COUNT(DISTINCT(COLLECT([Emp_Nbr]:[Emp_Nbr], Client:Client, @cell="Delta", Fleet:Fleet, @cell=320)))
You can get the mean average by combining this with the COUNTIFS from @Andrée Starå to make the whole thing a single formula:
=(COUNTIFS(Client:Client, @cell = "Delta", Fleet:Fleet, @cell = 320) / COUNT(DISTINCT(COLLECT([Emp_Nbr]:[Emp_Nbr], Client:Client, @cell = "Delta", Fleet:Fleet, @cell = 320))))
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!