Question about Microsoft Office Outlook 2003 for PC

1 Answer

Hi :Sum help

In the below table i need to add where the data where the rows are 'a' and columns are 'x': Sum(a,x)= 16 / Sum(b,y)= 15 etc. Can you please help. Thanks

x x y y a 1 3 1 3 a 2 5 2 5 a 4 1 4 1 b 4 1 4 1 b 3 4 3 4 b 1 2 1 2 c 4 1 4 1 c 4 4 4 4 c 4 4 4 4 c 4 1 4 1

Posted by on

1 Answer

In outlook or excel?

Posted on Sep 08, 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

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

Tip

Deleting Rows & Columns from the table


You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.
  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
OR
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

on Jan 29, 2010 | Computers & Internet

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

    2 Answers

    Count the number of open and closed order status per owner


    My suggestion is to use a Pivot Table.  Follow these instructions:
    Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

    Click NEXT on step 1 of pivot table wizard.
    For step two you will want to highlight all of the data on your sheet.  then click next.
    Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
    Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
    Regards,
    Joe


    May 07, 2009 | Microsoft Excel for PC

    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

    Excel formula


    Assuming that all of your data is in a single row number 4 and between columns N and PF

    Try:
    {=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

    The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

    The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

    Regards,
    Daryl

    Jan 25, 2008 | Computers & Internet

    2 Answers

    MS DATA DUPLICATE Problems


    You will need to state your problem Taru with a bit more explanation but to try to point you in the right direction....right clicking and clearing the contents of a cell, row or column works if I remember correctly.

    Jan 19, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

    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.

    thanks

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

    1 Answer

    Access Pasting Multiple data in the table


    When pasting data between tables, you have to make certain to select the exact number of rows and columns that you are going to paste into. For example, if you are pasting ten rows and ten columns of data, select (highlight in) from source table, Control C to copy, then go to destination table, select (highlight) ten rows and ten columns, then paste, either by right click and paste, or Control V.

    This should solve your issue, but if not please post back. Thanks for rating FixYa!

    Oct 03, 2007 | Microsoft Office Standard for PC

    Not finding what you are looking for?
    Microsoft Office Outlook 2003 for PC Logo

    Related Topics:

    121 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2642 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

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