Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can a numeric data be added in excel sheet? Suppose a numeric data is given from cell 1A to cell 30A, what will be formula to add them?

Office Administration Computer Skills
user-image
Question added by Suresh Prajapati , Office Assistant/ Academic Support Staff , IICT Bhadohi and MNNIT Allahabad
Date Posted: 2014/02/28
Upvote (0) Views (6) Followers (0) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
Mohammad Rizwanul Haque
by Mohammad Rizwanul Haque , Administration Manager , Oren Hydrocarbons ME FZCo.

Dear Mr. Suresh,

Thanks for your invitation, I am not an expert in MS Excel, But the formula to add from ( A1 to A30) will be the following

=SUM(A1:A30)

علي حسيب صديق الحيالي
by علي حسيب صديق الحيالي , معلم , مدرسة الماس الاهلية

it's as follow

SUM(A1:A30)

Divyesh Patel
by Divyesh Patel , Assistant Professional Officer- Treasury , City Of Cape Town

The formula for addind in an excel is =SUM(A1:A30)

Write Your Answer
More Questions Like This