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

CA Satheesh (Expert)
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


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details