Here's how to use Excel as a calculator to perform basic arithmetic operations such as addition, subtraction, multiplication, ...
All before dividing by the number of band members. Since multiplication and division come before addition and subtraction in the order of operations, subtracting expenses would need to be inside ...
From left to right, start with division and multiplication and continue with addition and subtraction. Don't forget, if a calculation has division and multiplication in it, do them left to right.