Question about Excel (SS8SATAS5128400R)

1 Answer

Excel question In excel, how do I continue calculating from one sheet to a second sheet? Please help

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 36 Answers

You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Posted on Dec 31, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Have a used laptop excel asks for product key but i click cancel and have used the software but now it opens and i can't edit or do anything is there a way to fix it or is there a way to download another...


MS Excel is not afree program.
You will need to purchase a copy of MS Office which includes Excel.
For an alternative free program OPEN OFFICE is a full-featured officesuite that's compatible with Microsoft Office.
If you want Open Office you can download this free program.
Click on this link to download :-
http://www.openoffice.org/

Mar 03, 2011 | Excel (SS8SATAS5128400R)

1 Answer

Nested IF functions in excel


Hi,

 

Your first IF condition is “=IF(C6>6000,0.15%*(C6-6000),0)”

Where:

C6>6000 is your logical condition

0.15%*(C6-6000) would be the value if your logical condition is TRUE, and

0 would be the value if your logical condition is FALSE.

 

Your 2nd IF condition is “(IF(C6>30000,0.3%*(C6-30000)))”

Where:

C6>30000 is your logical condition

0.3%*(C6-30000) would be the value if your logical condition is TRUE, and

? would be the value if your logical condition is FALSE.

 

You are missing the value if it is FALSE.

 

Hope this be of some help/idea. Post back how things turns up or should you need additional information.

 

Good luck and kind regards.

Oct 26, 2007 | Excel (SS8SATAS5128400R)

1 Answer

Prevention of delition of cell which has a formula


If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

Jun 16, 2008 | Excel (SS8SATAS5128400R)

2 Answers

How to recover password protected excel files?


You will need recovery software to recover password for the protected files
here is the link
link1
Excel Password Remover 2008
--------------------------------------------------------------------------------------------------
Low feed backs hurt my ratings and I tried my level best to resolve the issue. so please show your appreciation by rating it.
Thanks for using fixya support..You have a wonderful day


Jun 13, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Calculate a bill


Hi you can Apply below mention formula
=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.
CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

May 22, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Attendance sheet in Excel


Hi KDina,

If you need me to work on this project for you please contact me at hdbas8@gmail.com

May 17, 2008 | Excel (SS8SATAS5128400R)

1 Answer

FORGOT THE PASSWORD


Hi SAKHIE

You need to run a utility, link below
http://www.straxx.com/excel/password.html

May 07, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Forget excel 2003 password so how break it pl help


You can recover your lost excel password with the use of excel password recovery software likehttp://www.stellarinfo.com/password-recovery/excel-password-recovery.php
First use trail version if you are satisfied with result then go with full version?

Feb 16, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Plss help


With THIS program you can recover your password click here to download the software..

All the Best.

Was this solution helpful? Show your Appreciation by rating it and if your problem is solved. Please vote …… FIXYA..

Jan 14, 2008 | Excel DataNAS Director (DND1U45124250RERR)

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

137 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

2908 Answers

Bill Boyd

Level 3 Expert

33257 Answers

Lala

Level 2 Expert

34 Answers

Are you an Excel Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...