Hi everyone, please help me solve this problem. I have a spreadsheet that I am trying to automate the counting but it seems not working.
I am using countif to automate the counting but it seems not working.
I have attached a sample of what I am after. In the data, the red ones in column B are wrong (using the countif formula), the correct count should be like in column C.=COUNTIF($A$3:$A4,A3)
Untitled.png
If it is possible that anyone could help me out, that would be great.
Cheers,
Bookmarks