I need to create a formula for the following situation
Cell A1 will contain numbers (1-8) relating to people.
Cell A2 will contain a Total Time for a shift worked (ie. 4:00hours).
Cell A3 will contain the persons (ie. 1) total time worked.
I need a formula to say that if A1=1 then add A2 to A3
I will eventually have 8 people. So the formula will need to contain 8 if's I guess.
Help please...
Bookmarks