Count rows based on another column

jhorvath

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!

Christian Graf

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)

Christian Graf

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)

jhorvath

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

Christian Graf

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)