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!

Tags:

Best Answer

Answers

  • Christian Graf
    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)

  • @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
    Christian Graf ✭✭✭✭✭
    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)