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!