Excel Formula
This query is : Resolved
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?
Q.3 what is an array formula?
please help me by answering the above questions.
sankar Chakraborty
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?
Q.3 what is an array formula?
please help me by answering the above questions.
sankar Chakraborty
13 September 2009
Q1- You hav to do =Sum(go to sheet 1 sellect range & close with )then +again sum(sheet 2 range )+........enter
Q2- for summation of sum data use subtotal fist for all subtotal & grand total ( subtotal(9,data range)eter
Q3 ^ is used for computing nth power eg 10*10 is 10^2
Q2- for summation of sum data use subtotal fist for all subtotal & grand total ( subtotal(9,data range)eter
Q3 ^ is used for computing nth power eg 10*10 is 10^2
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- STCG....................................................
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- Sales return eway bill
- TAN for Partnership
- Is E Way Bill Valid If Transport ID Not Mentioned in PART A But Vehicle details mentioned in PART B
- Is it compulsory to File 10E if Income including Pension Arrears is below 12 Lakh for the F Y 25 26
- STCG FOR GOLD ETFs
- Last year TDS Claim
- E way bill for tractors
- Free lancer income
- Long Term Service award taxability in hands of company
- Standard Deduction claim for EPFO Pension and ICICI Prudential Life Annuity
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- Nomination of Bank for refund in itr 2
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
