Question about Microsoft Excel for PC

1 Answer

Horizontal Is there a way to dynamically summarize a row of data ($$) under a row of dates to include each new month. In other words can I create a YTD number at the end of the row, without having to re-create my data to ad each new month to the previous. Exampe 2007: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTDTotal 100 200 300 400 500 100 100 200 300 200 400 300 I want to create a YTD column at the end of the second row showing: 1500 YTD Total. Then for June include June dynamically (1600) etc.... Thanks! Phil

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 702 Answers

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.

Posted on Jun 24, 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

What is the meaning of rows?


In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:
sgoldberg08_1.jpg

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

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 make tally charts on my laptop?


    To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

    these are the steps involve
    -select the data to be use for graph.include the column and row label in sections
    -select data
    -click on number tab
    -click on text
    -click ok
    -click on chart wizard icon on the tool bar
    or
    click on insert on menu bar
    click on standard tab or custom types tab
    under chart type list ,click to select the desire chart type eg tally.
    under chart sub -type list,click to select the chart desire.
    click on next button.
    click on data range tab under series to select rows or columns.
    click on next button.
    that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you

    Oct 07, 2010 | Computers & Internet

    2 Answers

    How do i downlod microsoft word. Where is the cd


    http://www.microsoft.com/office/trial/

    you can check this website. microsoft office includes

    Word 2007Helps you create and share professional-looking documents and reports.
    icon-excel.png Excel 2007Helps you track budgets, keep track of data and make more informed decisions.
    icon-powerpoint.png PowerPoint 2007Helps you quickly create high-impact, dynamic presentations.
    icon-onenote.png OneNote 2007A digital notebook solution, allowing you to gather notes and information in one place.

    Mar 28, 2010 | HP Compaq nc4400 Notebook

    1 Answer

    I loaded MS Office 2003 on a new laptop running Windows 7, only to find that Word opens as a blank page with no toolbars, rulers etc - only the writing area. Excell works ok


    The Word 2003 Window When Word is first started, a new blank page titled Document1 is opened automatically. This is a fresh page where you can begin typing a new document.
    • At the top of the window is a row of menus, including File, Edit and View.
    • Below that row of menus is a row of buttons for various tools (collectively called the "toolbars") to use in creating and editing your document.
    Layouts in Word 2003
    Normal - Normal is the default Word 2003 view. It shows just the text that you are working on, without margins or header and footer information. It doesn't differentiate between different pages of text.
    Web Layout - The Web Layout displays the document as if it were a web page
    Print Layout - The Print Layout shows the entire page you are working on, including margins, header and footer information. It shows the layout of the text on the page the way it would be displayed if printed.

    Feb 05, 2010 | Microsoft Office 2003 Small Business...

    1 Answer

    I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


    hi Samajane,

    I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

    To convert the column wise data to row wise data.
    1.Select the data in your worksheet.
    2.Right Click -> Copy
    3.Create a blank worksheet.
    4.Goto Edit - > Paste Special
    5.Check the Transponse Option
    6.Press OK.

    Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

    Dec 14, 2009 | Microsoft Windows XP Professional

    1 Answer

    Create a class called Date in C++


    I wrote it for you:
    date.cpp
    date.h
    Remember, this is only a demonstration, so you can learn from it!

    Mar 26, 2009 | Computers & Internet

    1 Answer

    Procedure how to establish aging of account receivable in excel


    Once your data has been input into Excel - I assume you can do this via importing an outstanding debtors deport.

    The easiest way I can see is by Pivot Table.

    Your data should include open invoices and their respective due dates, it will be easier if you could covert these due dates into months - Create a pivot entering customer, outstanding values as your data and due months as your range.

    Feb 22, 2009 | Microsoft Computers & Internet

    1 Answer

    Excel support


    Hi,
    Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

    First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

    Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
    The next cell down has a value of ='DataRecord'!B971 and so and on until B974

    My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

    Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

    All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
    The graphs are automatically updated with the data each time the macro is run.

    You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
    Hope this helps.
    Glad to be of assistance - please rate the solution I can learn from you. Thanks

    Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

    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 Excel for PC Logo

    96 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

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