Count how many formula questions

Meny Hoffman

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?

Thanks in advance.

MH

Mark Cronk

Hi @Meny Hoffman ,

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

Mark Cronk

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

Mark Cronk

Hi @Meny Hoffman ,

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

Meny Hoffman

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

Mark Cronk

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

Be well,

Mark

Meny Hoffman

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

Your help is greatly appreciated!

MH

Mark Cronk

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

Meny Hoffman

Yes! Thanks.