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

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


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

  • Expert
  • 146 Answers
Re: Microsoft works

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

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

2 Answers

What is excel


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.


Jun 04, 2011 | Microsoft Excel for PC

3 Answers

Transforming birthdates into year codes

Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

5 Answers


No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.

Nov 26, 2008 | Microsoft Excel for PC

1 Answer


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:

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 plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

5 Answers

Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.


Dec 04, 2007 | 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:


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


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 | Business & Productivity Software

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

Related Topics:

82 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides