+ Reply to Thread
Results 1 to 11 of 11

Accounting i guess

  1. #1
    Registered User
    Join Date
    04-17-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    12

    Accounting i guess

    I need to make a sheet with a list of active employeesdown column A. If anY text is found in A I need it to multiple that row B through H and put total into I. Is there any easy way to do this so that every time I add or remove an employee it auto figures the formula?

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Accounting i guess

    can you uplaod a sheet with sample data to clarify your request
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  3. #3
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Accounting i guess

    Dont know if it works in 2003 but if you have 4 or more rows of data with the same formula in 1 column, when you fill in another row the formula will copy down automatically as if it was in a Table.

  4. #4
    Registered User
    Join Date
    04-17-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Accounting i guess

    Pens Paper Ink Total
    Jon 1 0 0
    bob 0 0 1
    Steve 4 7 0
    New Employee added here


    In a perfect world i will have the B, C, D cells take the number input times the price of item. Then the total put in E. Not a big problem there. The thing is this is going to be done across multiple departments and 1000 people. I need Excel to know that if any text is in any cell in the A column then it needs to take the numbers from B C D in that row and add them into E. I could go if A1 then, or A2, so on but i need it so people under me can input the name and amount and not have to worry about the formula. I hope this makes sense.
    Last edited by Duggie06; 04-17-2012 at 11:00 AM.

  5. #5
    Registered User
    Join Date
    04-17-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Accounting i guess

    This is a quick mock up of the sheet im looking for
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Accounting i guess

    im not quite sure what you mean is this right?



    example (1).xls

  7. #7
    Registered User
    Join Date
    04-17-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Accounting i guess

    Thats what I need but I dont want to have to type the formula for every cell in column E. I there a way on the page as a whole IF(A<>"",SUM(B:D),"")

    Im sorry im still new at excel i guess it could be something very simple i just need it to know if anything is found in A then that row needs to follow said formula

  8. #8
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Accounting i guess

    you just highlight the cell and then click the bottom right corner and drag it as far as you need.

  9. #9
    Registered User
    Join Date
    04-17-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Accounting i guess

    Simple as heck. Dang I feel stupid thank you so much twiggy huge help!!!!!!!

  10. #10
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Accounting i guess

    no problem glad to help.

    remember if a post helps to hit that lil star button

  11. #11
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Accounting i guess

    How does your thread title have anything to do with the question?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1