Question about Microsoft Works 8.0 for PC

Ad

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

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

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".

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

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

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

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
Thanks for choosing Fixya............
Sandeep

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.

Mar 18, 2011 | Computers & Internet

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

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

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...

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.

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

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.

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

hi this my id :[email protected] plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

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

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

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.

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

May 05, 2010 | Microsoft Works 8.0 for PC

86 people viewed this question

Usually answered in minutes!

×