How to create this formula on Appshet
Try to use count(select(tablename[resultcolumn],[searchcolumn]=[factorvalue]))
Well, it appears you simply want to count the number of times any person appears and the formula provides the cumulative count for any person for that row from the onset.
Note that it starts from 0 so best to add 1 (=COUNTIFS($B$1:B1,B2) +1)
So it is not necessary to have such a column as you may simply use a UX Table view with aggregation to do this and more elegantly
So just using the names column create a UX Table View as such
and this will provide you with the following Table view
So now it groups by each user and also shows the row in which the user appears and as you see corresponds directly with your Sum Before Column except I added 1 as noted above.
So without additional columns or formulae, you effectively get a condensed view per user rather than having to look for each user throughout the table. The UX Table View GROUP does this for you.
Hope this helps.
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |