(No VBA) Count of a Text Value in a Table Column, Running Total of Occurrences by Rows in a Separate Column

[DaddyO]

In a table with structured reference:

One column with rows containing multiple text values.

In another column, a running total by row of the number of occurrences in the column one of those text values.



WorL, Running Total Wins
W, 1
W, 2
L, 2
L, 2
W, 3
L, 3
L, 3
L, 3
W, 4

The rows in a third column contain unique incrementing GameID numbers.

I'd like to base the running total in each row comparing the [GameID] value in each row to the value in the current row like this: "<=[@[GameID]]" . But my attempts to create a formula that works have not worked so far.

I do not want to employ VBA, only Excel functions.

Any help is appreciated.

 

[geo77]

This is not hard, however the request is unclear. Please post the image of a sample table (where you calculate everything by hand) and name the cells that the function needs to fill. Make sure the table has at least 15-20 rows.

 

[DaddyO]

Thanks for you reply. Here is an image of 20+ rows of the columns in question. Let me know if you need any other info.

Hmmm, I added an image via link but it doesn't show up after posting. I'll have to figure what I'm doing wrong. It's been a LONG time since I've been on this forum. Bear with me, please. Looks like I may also need help how to post an image. I'm used to being able to upload images directly to a forum post.

 

[DaddyO]

 

[mrshl9898]

=countif(i$2:i2,"w")

 

[DaddyO]

Thanks, it worked of course. I guess I was stuck trying to do it with structured references. Your solution is much more efficient in this case. Again, thank you!

 

[Peter_SSs]

I guess I was stuck trying to do it with structured references.

If you did want to do it with structured references (has the advantage that it would still work if a new table row was inserted immediately below the table header row) then you could try this.

Excel Workbook
	I	S
1	Dec	Tm_W
2	W	1
3	W	2
4	L	2
5	W	3
6	W	4
7	W	5
8	L	5
9	L	5
10	L	5
11	L	5
12	L	5
13	L	5
14	W	6
15	W	7
16	W	8
17	L	8
18	W	9
19	W	10
20	W	11
21	W	12
22	W	13
23	W	14
Count Wins

 

[DaddyO]

Thanks for the St.Ref. help. When I use it it gives me a return of "FALSE." Not sure why, since clearly it worked for you. I just copied and pasted your formula.

https://1drv.ms/u/s!ArIAG4a3p8D7h5Z8ujgm3t_-HjIcmA

Oh, and thanks for the How To Post An Image help. I had figured out last night that I was overthinking things, that I could just paste the link directly into my post.

 

[Peter_SSs]

When I use it it gives me a return of "FALSE."

Do you have Custom Formatting in those cells?

 

[DaddyO]

Do you have Custom Formatting in those cells?

It just so happens I did have color formatting with a bold font, but when I decided to make this a source table I removed it. So as of now there is no Custom Formatting.