# Count how many formula questions

✭✭✭✭

Hello All:

I'm working on a product development sheet and we have products going live in different months, I created a column that has a drop-down for each month where I select the right month on the product row.

The question I want to easily sum how many products we have lined up by month. What would be the easiest way to achieve this?

MH

Tags:

• ✭✭✭✭✭✭

You can build the count formulas in the sheet summary. From there you can use them in a report or dashboard or just view them in the summary.

Build a field for each month. The formula for January would be =COUNTIF([Month]:[Month], "January")

You'll need to change [Month] to the name of your month column. Since you're using drop downs your month is going to be text, not a date. Copy and past 11 times to create a fid for each month.

If you have more than 1 year in your sheet you'll need to add to the formula to only count the current year.

Help?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Hi Meny,

For a single criterion you would us a SUMIF formula. The syntax is: =SUMIF( range, criterion, [ sum_range ])

Your formula would be along the lines of:

=SUMIF(month:month, "January", cost:cost)

It says, where the month is January, sum the costs.

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

You can build the count formulas in the sheet summary. From there you can use them in a report or dashboard or just view them in the summary.

Build a field for each month. The formula for January would be =COUNTIF([Month]:[Month], "January")

You'll need to change [Month] to the name of your month column. Since you're using drop downs your month is going to be text, not a date. Copy and past 11 times to create a fid for each month.

If you have more than 1 year in your sheet you'll need to add to the formula to only count the current year.

Help?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭

@Mark A Shampine Thank you so much, this worked!

• ✭✭✭✭✭✭

Gappy to help Meny. Please accept my answer to close the discussion.

Be well,

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭

@Mark Cronk a quick follow-up question. I have another column which calculates the total cost for each product, how can I create a total of all cost that will calculate the total all products that have [Month], "January"

MH

• ✭✭✭✭✭✭

Hi Meny,

For a single criterion you would us a SUMIF formula. The syntax is: =SUMIF( range, criterion, [ sum_range ])

Your formula would be along the lines of:

=SUMIF(month:month, "January", cost:cost)

It says, where the month is January, sum the costs.

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭

Yes! Thanks.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!