Numbers - Countif question

[Winehouse]

Hi

I have a column of dates with the end of the year top, going down to the start of the year at the bottom. I'd like to count the number of occurrences of a letter in the next column using countif. However, it displays the occurrences 0,1,2,3, whereas I'd like to see them 3,2,1,0. Is there a way to display them as they occur during the year, or will I just have to change the date order?

Thank you

 

[Eric W]

Maybe:

Book1
	A	B	C
1	Date	Letter	Instance
2	12/1/2022	A	5
3	11/1/2022	B
4	10/1/2022	C
5	9/1/2022	A	4
6	8/1/2022	B
7	7/1/2022	C
8	6/1/2022	A	3
9	5/1/2022	B
10	4/1/2022	C
11	3/1/2022	A	2
12	2/1/2022	A	1
13	1/1/2022	C
14
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=IF(B2="A",COUNTIF($B$2:$B$13,"A")-COUNTIF($B$2:$B2,"A")+1,"")

 

[Joe4]

Is this an Excel or a Google Sheets question?

I ask because you posted this in the "General Discussion & Other Applications" forum instead of the "Excel Questions" forum (which is where Excel questions typically go), though you made no mention of Google Sheets, and the answers are not always the same between the two programs (so it is important for the responders to know which one you are using).

 

[Winehouse]

Maybe:

Book1
	A	B	C
1	Date	Letter	Instance
2	12/1/2022	A	5
3	11/1/2022	B
4	10/1/2022	C
5	9/1/2022	A	4
6	8/1/2022	B
7	7/1/2022	C
8	6/1/2022	A	3
9	5/1/2022	B
10	4/1/2022	C
11	3/1/2022	A	2
12	2/1/2022	A	1
13	1/1/2022	C
14
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=IF(B2="A",COUNTIF($B$2:$B$13,"A")-COUNTIF($B$2:$B2,"A")+1,"")

Thank you. I'll give it a try.

 

[Winehouse]

Is this an Excel or a Google Sheets question?

I ask because you posted this in the "General Discussion & Other Applications" forum instead of the "Excel Questions" forum (which is where Excel questions typically go), though you made no mention of Google Sheets, and the answers are not always the same between the two programs (so it is important for the responders to know which one you are using).

I put it in the title. Numbers

 

[Joe4]

Sorry, I didn't realize that was the name of the program you are using (we rarely get "Numbers" questions).
I thought it was more of as description of what you were trying to return.