Count rows based on another column
I have a sheet like this:
Case number | Date entered | Cases/day
I want to count the number of cases per date entered. I'm assuming I would use the COUNTIF formula but I'm not sure how to tell it to count the cases for each date as opposed to if the date = some value.
Thanks!
Best Answer
-
Okay,
If you put the following formula in the cases/day column and make it a column formula it should work.
=COUNTIF([Scan Date]:[Scan Date], =[Scan Date]@row)
Answers
-
So you are trying to populated the cases/day column? Could you share an image of the Sheet? It is unclear what you are trying to do.
Something like this?
=SUMIFS([Case Number]:[Case Number], [Date Entered]:[Date Entered], (Date Entered)@row)
-
@Christian Graf Here is what I'm working with:
A column might not be the best way to do this now that I think about it. But I need to sum the number of rows for each date, so in this example I have two dates. I need to gather data that says that on 2/23/22 there were 7 cases, and 4 cases on 3/3/22.
-
Okay,
If you put the following formula in the cases/day column and make it a column formula it should work.
=COUNTIF([Scan Date]:[Scan Date], =[Scan Date]@row)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives