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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives