Forum Discussion

Filip_Rozkosny's avatar
Filip_Rozkosny
Copper Contributor
Jun 30, 2020

Excel Countif - actual counter

Dear all,

could you please help me?

 

I am using Countif function in the column next to database and it is giving me just the total counts but is there any other function which can give me exact counter ?

Example attached - Column C is what i am looking for but i have to do it manually, is there any function which can help me?

Many thanks in advance.

excel

5 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jun 30, 2020

    Filip_Rozkosny 

     

    I think this is what you're looking for. I changed the formula you had so that it's only looking at column A for the current and preceding rows. The way you'd written it it was always comparing the value in the current row with all rows.

    Your original: =COUNTIF(A:A,A2)

    Corrected:      =COUNTIF($A$2:A2,A2)

     

    The absolute reference $A$2 anchors the range, and then allows the other (relative) one, A2, to change as it is copied down the column.

     

    But I am making the assumption that this is what you wanted because it does deliver the number you seem to want. You didn't actually describe HOW you arrived at your "Requested data" manually. So I made an inference which did come up with the same answers....that still could be coincidence.

Resources