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
- Price inclusive or exclusive of GST while made entry in P& L Account
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Gst registered proprietorship firm
- Minimum tax payable to file Updated return
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Dep. as per companies act
- Applicability of GST on Salary Reimbursement Component
- TDS on purchase of under construction property from a reseller
- Tax rate change regarding
- Salary from Qatar in Dollars in India
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
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
Quick Links
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared
Getmyca Consultant Pvt Ltd
New Delhi
CA Inter
View Details
ARTICLESHIP
18 September 2026
Industrial Trainee
Twenty Point Nine Five Ventures Private Limited
Noida
CA Inter
View Details
CCI
Pro
CAclubindia
