Question about Microsoft Works 8.0 for PC

1 Answer

Microsoft works I created a new spreadsheet in works and I find that the Sum function does not always work properly.  In row of 12 cells (months) if all cells contain data the sum function apparently adds the last cell in the row twice.  This gives me an wrong total.

Posted by on

Ad

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.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers

First check the formatting of the cells, then check under file-preferences to see what works is programmed to do, if this gives no clue, you could easily create a copy to experiment on and on the copy, highlight the entire sheet, and clear all functions and formats, then experiment with your calculation, if it performs ok, you will know that there was something else going on in the original cells. Finally, instead of the auto-sum function you could manually put in the sum formula eg D2=sum ( A34:A57)
If all this fails, post back and we'll dig further......good luck

Posted on Jan 09, 2008

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

3 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    How to delete the nulls cells?


    Try create a new Workbook (file) and then copy only the 10x200 cells from the NULL'ly spreadsheet. Unless you have macros in the nully one, it should be resolved by copying the needed cells to blank new file.

    Apr 17, 2009 | Microsoft Computers & Internet

    1 Answer

    If/Then Formula


    not really
    Just create the
    formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then
    formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then
    formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then
    formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then
    if you wanted another statement
    formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1
    this is nesting the if statement you just keep adding conditions.
    What you are asking I have to type this in 600 times
    No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy
    Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

    You could also use a vlookup statement
    you open another workbook look at bottom of worksheet for tabs to add a workbook.
    Then you create a table in other workbook
    1 cell A1 H in B1
    2 cell A2 Z in B2
    https://www.timeatlas.com/vlookup-tutorial/
    you would still need to copy the cells down

    Mar 30, 2017 | Microsoft Office 2003 Basic Edition...

    1 Answer

    Horizontal


    Not sure if I get your problem. Do you mean the SUM() formula with the row does not work?
    That is the simplest solution if you are entering the monthly numbers per month.

    If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.

    Jun 23, 2008 | Microsoft Excel for PC

    1 Answer

    Average handle time


    I have created a spreadsheet for you to a) use and b) to learn from.

    It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

    It also allows you to calculate a Part Month average.

    I have displayed it as it was CONSTRUCTED and as it would be USED.

    The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

    To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

    All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

    The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

    You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

    I have uploaded the file to here:

    http://users.tpg.com.au/lesliecl/

    Hope this gives you the push to really start using Excel.

    Apr 04, 2008 | Microsoft Excel for PC

    2 Answers

    Should I use countif or if or what ??


    hi this my id :dadu_mf@rediff.com plz send excel material

    Mar 25, 2008 | Microsoft Excel for PC

    1 Answer

    Multiple letters in each cell, want to add the letters and tally how many of each


    Use the =COUNTIF function


    For example if column a has the letters in it:


    =COUNTIF(a1:a100,"a")
    or
    @COUNTIF(a1..a100,"a")


    This will count all of the letter 'a' s in
    column a from row 1 to row 100.

    Mike

    Oct 31, 2007 | Microsoft Excel for PC

    2 Answers

    Budgets in excel


    Dear Madiha35,

     

    I would recommend the use of the Table Function in Excel.

     

    Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

     

    Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

     

    Excel 2007 had a budget format workbook

    New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

     

    Step 1:  Enter your data into the worksheet.

     

    Step 2:  Create Table

                 Highlight the relevant data

                 On the insert tab, click on Table

                 

    Step 3:  Verify Table range is correct, Click OK

     

    Step 4:  Select the cell you where you wish to Sum Data.

             Click on Autosum.

     

    Step 5:  To Insert new data

             Click on the sum row in the table, (Not the entire worksheet row)

             Right click, Insert, Insert Table rows from above

     

    Step 6:  Enter new data in row

     

    Step 7:  Data is automatically calculated in formula.

    Oct 22, 2007 | Computers & Internet

    Not finding what you are looking for?
    Microsoft Works 8.0 for PC Logo

    85 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    3003 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18424 Answers

    Alun Cox

    Level 3 Expert

    2678 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...