Need help with complicated formula
As usual, Im having a hard time developing a complicated formula. @Paul Newcome helped me last time with a great solution. Im hoping someone can help untangle the webs for me.
I have a sheet that has (among other things) a Date column, another column with a formula that determines a number of days, and a month number helper column.
What I need to do is to count the 9th column and break it into 2 buckets (columns) per month on another sheet.
The other sheet will look similar to this:
Month Bucket1 (if number is 110) Bucket2 (if number if 11+)
Jan X X
Feb X X
Mar X X
Im trying to figure out how to fill in the numbers for each bucket.
Comments

Exactly which column are you trying to break down into the buckets?

The column that shows the number 12.
The column that has the green 12 is a formula. The column to the right of it is really just a duplicate that I can get rid of. As you can see some of the rows have a value and some do not. I am only concerned with the ones that have a value.

Ok. And can you provide a screenshot with manually entered data that shows exactly what you are trying to accomplish?

Hope this makes it more clear. :)

Ok. So how exactly did you determine the number 4 goes in the 110 Bucket column and the number 3 goes n the 11+ Bucket column?

There are 4 rows in the Average Time column that are between 110.
There are 3 rows in the Average Time column that are between 11+
There are 7 total rows with numbers in that column.
I need to capture these counts per month.

Oh. So you are just trying to get a count. Try this...
=COUNTIFS({Date Column}, IFERROR(MONTH(@cell), 0) = 6, {Number Column}, AND(@cell <> "", @cell <= 10))

Hi Paul,
I think that is working. Need to do some more checking.
Would you mind explaining what this means? This is similar to the past formula you helped me with, which I tried to make use of before posting here, but I just dont understand what this means.
Count date_column if month=6, AND number_column is not blank and <=10
Is this correct?

That is correct. The only reason for the AND function is to combine the criteria for the second range so that we do not have to repeat the same range multiple times. It helps me personally keep things organized in really long formulas so that I can make sure I didn't miss anything.

Cool. Thanks so much.
Glad to know I was on the right track before posting my question. It seems to be working great!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!