sharepoint - How can I perform a mathematical function in Column A, where Column B equals a specific value? -

for example, if have 2 lists, alpha , bravo, list alpha operational list, , list bravo draws list alpha display information administrators:

list alpha (source list)

column (player name)/column b (number of home runs)
john/2
john/5
john/11
mary/3
suzy/7
suzy/6

list bravo (administrator list)
column (name)/column b (number of items in other list)/column c (total hrs)
john/3/18
mary/1/3
suzy/2/13

or:

1. list bravo column shows single instance of each name appearing in list alpha column a.
2. list bravo column b counts number of items in list where: list bravo column = list column
3. list bravo column c adds list alpha column b where: list bravo column = list column

i apologize if i'm being unclear, first attempt @ writing question. thank in advance assistance.

"thank you. second list not needed. how set double grouping achieve result?" -darryl cooper

this explanation sharepoint 2013. menu may vary other versions.

navigate list -> in ribbon select "list" -> "create view" -> "standard view" -> enter view name -> "create personal view" -> "select columns should shown (name/homeruns) -> expand "group by" section -> first column group "name" second "homeruns" -> expand "totals" section -> "homeruns" "sum" -> finish creating view

as might realize generate view yourself. not possible customize access view oob functionality.

here options overcome that:

free:

every administrator creates view himself. note user might same without knowing it.

create view everyone. if user has access list information anyway. -> in view creation menu select "public view"

$$:

custom view permissions