Question about Microsoft Windows XP Home Edition

1 Answer

ADDING CELLS hOW DO I ADD A CELL WITH A SUM FORMULA TO ANOTHER CELL WITHOUT A FORMULA

Posted by on

  • 1 more comment 
  • Leeanne Hand Sep 16, 2008

    i HAVE A WORKSHEET FOR LOANS MY TOTAL IN A COLUMN D248 IS =SUM(D217:D247) i THEN HAVE A NEGATIVE AMOUNT IN D249 WHICH I NEED TO ADD TO THE ANSWER IN D248

  • Leeanne Hand Sep 17, 2008

    iT DID'T ADD THE ANSWER WAS 0

  • Pav Z May 11, 2010

    Can you provide more details or may be example?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 50 Answers

Just put to D248 following formula

=SUM(D217:D247)+D249

Posted on Sep 16, 2008

  • Pav Z Sep 17, 2008

    What happen if you do if this way:
    1. D248 = SUM(D217:D247))
    2. E248 = D248 + D249

×

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:

1 Answer

How can sum a time row in excel


Select the row which you want to Sum and press "ALT+" key.

or

you can just select the row and click " ? " this symbol which will be on the tool bar in the excel sheet
or go to formulas tab in that you can find "Auto sum ?"

Jun 03, 2011 | Computers & Internet

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

1 Answer

How to get all balance sheet entries tally to excel


This is a very handy process when you're totaling or subtotaling columns. On the cell that you want the 'total' in type '=sum(column letter row number),(column letter row number). The first 'column letter row number' is where you want the first cell to be started in the total factor and the second 'column letter row number) is the last cell you want added in the total factor. The help (?) section is good at explaining formulas. Hope this helps, keep this process handy if you use Excel much because it'll be helpfull each time you subtotal or total columns.
Bob

Sep 23, 2009 | Computers & Internet

2 Answers

HOW TO PROGRAM ARITHMETIC ALGORITHM( ADDITION)IN C++


above int main () you will want "using namespace std;" without quotes. Under that, "int main ()" without quotes, then a [ bracket to start the main function.
Please rate, thanks!

Mar 16, 2009 | Computers & Internet

1 Answer

Finding the right formula


Assumption:

  1. we work on sheet1, cell b1 as description of material and cell e1 as quantity figure.
  2. we will put the transfer the text in cell b1 to sheet2 cell a1 if you have entered some value in sheet1 cell e1. Otherwise sheet2 cell a1 will left empty or display some text as "NONE" or as you wish.
what you should do is make a formula in sheet2 cell a1 like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"")

The formula will check sheet1 cell e1, if there is any number or text put in there, the value of Sheet1 cell b1 will be copied to sheet2 cell a1. If you don't supply any number or text in sheet1 cell e1, there's nothing will appeared in sheet2 cell a1.

If you want some text will display when there's no value in sheet1 cell e1 just change the formula like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"NONE")

You can modify it as your like. Just copy the formula to another row in sheet2 column a.


P.S.: If this information was helpful, please rate this solution.
1ak+f4pj7cbm32cuniyi2gaaaaaelftksuqmcc

Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC

1 Answer

Spreadsheet formulaes


1. enter = symbol
2. enter ( symbol
2. enter cell location where your cost value is
3. enter * symbol
4. enter 0.7
5. enter ) symbol
6. enter 0.175


eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

Works suite 2006 spreadsheet


THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

1 Answer

Read n & m, display the sum of all the even and odd numbers between n to m.


#include <stdio.h>

int main()
{
int n1, n2, i;
int sum = 0;
n1 = 3;
n2 = 11;

for (i = n1; i <= n2; i++) {
if (i % 2 == 0) {
printf("Adding %d\n", i);
sum = sum + i;
}
}
printf("sum = %d\n", sum);
return 0;
}

Feb 21, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Windows XP Home Edition Logo

Related Topics:

67 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...