12 September 2009
Q.1 An excel file has eight sheets and each sheet contains total amount in numeric. i want to sum of all eight sheets in a new sheet by using an excel formula.
please let me know the formula by which i can summation grand total.
Q.2 i have seen in a excel formula the symbol '^' is used as a part of that formula. what calculation is possible by using this?