hello
I'm working on a shift arrangement file in excel, and i want that every week the excel will sum automatically the number of hours that every worker worked..
now i am sum this manually.
the issue is that i want the excel will recognize letters as the numbers that i will initialiize to it.
like : a=2, b=5 , c=1.
and : sum = a+b+c+c = 9
excel forum.PNG
how can i do this ?
i have knowledge in some programming languages
thanks
Bookmarks