Trying to count total number with specific column

Adrian L

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?

juliesilverio

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

@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

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

@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.

juliesilverio

@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?

Adrian L

@juliesilverio - This worked!! Thank you so much! I appreciate you!

juliesilverio

@Adrian L you're welcome, happy to help. :)