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
- Tax on Deemed Capital Gain
- Type of Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Regarding ITR filing with more value than showing in AIS/TIS
- Exiting partner in partnership firm in gst portal
- Banking Related Issue
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- IT returns for fresh job holders
- Due Date Clarity
- NRI INSURANCE ADVISOR
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- TDS offline utility
- TDS on rent received on hardship compensation being rent on redevelopment of building
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
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
