Trying to count total number with specific column
Hello,
I am trying to count the total number in one column IF the other column is in a certain quarter.
=IF([Quarters]="Q1", COUNT([??]=2)
Is this even possible?
Best Answers
-
Hi Adrian,
You're on the right track but you'll want to combine the COUNT and IF functions for COUNTIF. Below is the formula to use for Q1 as an example:
=COUNTIF([Quarters]:[Quarters], "Q1")
This formula will count all cells assigned Q1.
I reread your question and it seems you might want to sum a total in a column based on quarter, in which case you'll want to use SUMIF, example below:
=SUMIFS([Number]:[Number], [Quarters]:[Quarters], "Q1")
Hope that helps!
-
@Adrian L Hi Adrian! I reread your question and initially updated my answer before I saw your response.
To set that up, you'll want to use a SUMIF formula, exampled below:
=SUMIFS([Number]:[Number], [Quarters]:[Quarters], "Q1")
The [Number] portion will be the column you want Smartsheet to sum when the quarter is assigned to Q1 in this example. Then you can copy the formula and update with the other quarters to get their count as well.
Did I understand this correctly this go around?
Answers
-
Hi Adrian,
You're on the right track but you'll want to combine the COUNT and IF functions for COUNTIF. Below is the formula to use for Q1 as an example:
=COUNTIF([Quarters]:[Quarters], "Q1")
This formula will count all cells assigned Q1.
I reread your question and it seems you might want to sum a total in a column based on quarter, in which case you'll want to use SUMIF, example below:
=SUMIFS([Number]:[Number], [Quarters]:[Quarters], "Q1")
Hope that helps!
-
@juliesilverio - Thank you! I need to explain a little better:
Here is the next step, I want it to count another column if they have a 2 in it. So in a sense it is, If Quarters column has Q1 then I want to know how many 2's are in column completed. So I want to know how many completed files in Quarter 1.
-
@Adrian L Hi Adrian! I reread your question and initially updated my answer before I saw your response.
To set that up, you'll want to use a SUMIF formula, exampled below:
=SUMIFS([Number]:[Number], [Quarters]:[Quarters], "Q1")
The [Number] portion will be the column you want Smartsheet to sum when the quarter is assigned to Q1 in this example. Then you can copy the formula and update with the other quarters to get their count as well.
Did I understand this correctly this go around?
-
@juliesilverio - This worked!! Thank you so much! I appreciate you!
-
@Adrian L you're welcome, happy to help. :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!