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

• ✭✭✭✭

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!

Julie Silverio, PMP

Xencor Inc.

https://xencor.com/

• ✭✭✭✭

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?

Julie Silverio, PMP

Xencor Inc.

https://xencor.com/

• ✭✭✭✭

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!

Julie Silverio, PMP

Xencor Inc.

https://xencor.com/

• ✭✭

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

• ✭✭✭✭

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?

Julie Silverio, PMP

Xencor Inc.

https://xencor.com/

• ✭✭

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

• ✭✭✭✭

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

Julie Silverio, PMP