Question about Microsoft Windows XP Home Edition

1 Answer

Works suite 2006 spreadsheet

I need to write a formula to sum a column of numbers in spreadsheet. Every formula I try based on Excell yields an error message.

Posted by on

  • Erichumins Mar 02, 2008

    The post system does not recognize the product Microsoft Works Suite 2006, so I entered the name XP Home Edition. The spreadsheet program I have is a part of the Media Center Edition.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

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

Posted on Mar 03, 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:

1 Answer

7. Program to manipulate N student details and sort the structures as per total marks obtained by them, by creating a structure to store the following details. Roll number, name, marks1, marks2, marks3


You can use Windows Excel
or
Adobe Open Office (free)

Select 'Spreadsheet' and away you go
The column width can be adjusted to suit the text
Text size is adjustable
Exam marks 1.2,3,4 etc can be auto calculated
Suggested format below (Open Office)
Name Fred Mary Jane



Roll 1 2 3



Exam 1 75 55 73



Exam2 80 81 82



Exam 3 66 71 90







Total 222 209 248

Mar 04, 2015 | Computers & Internet

1 Answer

How to open Book1.xls file.?


To open an Excel spreadsheet, you need a program that understands the .xls format. You can get the free Excel Viewer from Microsoft: http://www.microsoft.com/en-us/download/details.aspx?id=10 . This is the latest version and will work with computers running Windows XP through Win7. There is a Mac OSX version available but I'm not sure of the URL. If you have an older OS, you can try searching for an older version of the Viewer.

Another option is to install any office suite that includes a spreadsheet program or just the spreadsheet program. Microsoft sells Office in several versions and you can buy Excel separately. There are several other spreadsheet and office suite software options that will also read Excel files. Open Office and LibreOffice are both free office suites which can read any Excel file. (www.openoffice.org and www.libreoffice.org ) Open Office and LibreOffice have versions that work under almost any OS.

I hope this helps.

Cindy Wells
(who has used the MS Word and Excel viewer and OpenOffice on recent systems. I also have MS Office 2010 on some computers.)

Sep 08, 2012 | Microsoft Computers & Internet

1 Answer

Can I use excell of microsoft office in data base programming?


Excel is a spreadsheet program. You can do lots of programing applications with Excel. A more advanced database managing program within the Microsoft Office set is Microsoft Access. It comes with Office Pro and above. Otherwise it is sold separately.

Here are some basic tutorials on Excel:

http://people.usd.edu/~bwjames/tut/excel/

I love Excel! Lots of fun!

http://www.excelgames.org/

May 27, 2011 | Microsoft Computers & Internet

1 Answer

IM JUST ASKING ABOUT THE PARTS OF THE OPEN OFFICE?? WHAT ARE THE PARTS??


Open Office is an open source office suite consisting of 5 main parts; Writer: a text editor like MS Word, Calc: a spreadsheet program like MS Excell, Impress: a presentation builder like MS PowerPoint, Draw: a simple yet effective graphics generator, and Base: a database builder.

Nov 02, 2010 | Computers & Internet

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

I NEED TO START A SPREADSHEET FROM SCRATH I AM A BEGINNER AT COMP


I am assuming that you want your date column to run daily - not updating itself with todays date over previous data....

In which case your column will run a daily date, You can achieve this by typing a date in the format you choose = 01/05/09, 1 May 09, etc hit return. scroll on the bottom corner of the cell you have typed the date in until it changes from a large white cross to a smaller cross and drag this down the column.

For the totals that need to subtotal autmoatically you will need to select a range - so is this total a weekly/ monthly total - How large is your range.

Once you have decided on the above - for example the in Column A the date ranges from 1st May - 31st May for a calendar month, the subtotal will need to include 31 cells - so in the Column B which is the subtotal = SUM(B2:B32)

You can copy and paste the sum into adjoining cells if you are seperating income from expenses etc.

Hope this helps.

May 21, 2009 | 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

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

ADDING CELLS


Just put to D248 following formula

=SUM(D217:D247)+D249

Sep 16, 2008 | Microsoft Windows XP Home Edition

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

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