Count formulae
Hi all,
Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations:
- To calculate the count of 'Medical Device Related' category from the 'Relevant System' column
- Same as the above but for 'Non-Medical Related' category
I want to have a breakdown of the sub-categories for each of the above categories which have a summary sheet cell, so for example ' Number of 'Medical Device Related' with 'approved' status (Status column).
- To calculate of the 'Medical Device Related' category, how many have a status of 'Approved' etc (I would apply this formula to all categories).
All this information is to feed widgets in a dashboard.
I have tried CountIF/ but it is unparsable.
Please see the attached screenshot - this data is all dummy data.
Answers
-
Hi @BGuest,
You do indeed want to use COUNTIF/COUNTIFS here.
In your first question:
For medical device related:
=COUNTIF([Relevant System]:[Relevant System], "Medical Device Related")
For non-medical device related, you would simply change the text within the quotation marks.
For the second part where you want several criteria, you use COUNTIFS instead. In your example of "Medical Device Related" in Relevant System & "Approved" in Status:
=COUNTIFS([Relevant System]:[Relevant System], "Medical Device Related", Status:Status, "Approved")
Hope this helps, but if you've any problems/questions then let us know.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!