+ Reply to Thread
Results 1 to 10 of 10

keep a running tally on sheet 2

  1. 11-26-2007, 04:26 PM #1
    PatrickB
    PatrickB is offline
    Registered User
    Join Date
    11-26-2007
    Posts
    5

    keep a running tally on sheet 2

    Hello i am currently trying to figure out excel i have to fill this worksheet out daily and then at the end of the month i have to count the total number of items. I was wondering if there was a way to auto talley on a different sheet so that everytime i entered a product name and quantity if on the other sheet it would auto add it in example:
    I ate at mcdonalds (Main sheet)
    On 11/22 I had 3 big macs and 4 quarter pounders,
    On 11/24 I had 5 Big Macs and 2 quarter pounders
    On 11/26 I had 12 Bigmacs and 5 quater pounders
    (New Sheet) i want it to look like this:
    Product quantity
    Big macs (20) <-- this number i want to auto add from the notes made from main sheet)


    So on another sheet i want to make a formula where for everytime i type in "big mac" on main sheet that on the other sheet it would auto add or keep a running tally so after i made those 3 entries on the main sheet it would show that i had a total of 20 big macs on the new sheet. What formula would i need to make that happen?

    Can anyone help me out with that formula?

    Thank You,
    Patrick
    Reply With QuoteRegister To Reply
  2. 11-26-2007, 04:31 PM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try looking into the Sumif function in Excel help files...

    e.g. =Sumif(Sheet1!A:A,"Big Mac",Sheet1!B:B)

    this would some the values in Sheet1, column B when column A contains the words "Big Mac".
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 11-26-2007, 04:52 PM #3
    PatrickB
    PatrickB is offline
    Registered User
    Join Date
    11-26-2007
    Posts
    5
    I am confused i just tried your formula but i think i did it wrong because its not auto adding it up for me?
    Reply With QuoteRegister To Reply
  4. 11-26-2007, 04:55 PM #4
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    My formula assumes your sheet name is the default "Sheet1" and it assumes you are entering the food item (e.g "Big Mac" without the quotes, in column A) and you are entering quantities in column B..

    You need to change any of these assumptions to match your actual data...

    If you still have trouble, attach a sample sheet (zipped Excel2003 file).
    Reply With QuoteRegister To Reply
  5. 11-26-2007, 05:46 PM #5
    PatrickB
    PatrickB is offline
    Registered User
    Join Date
    11-26-2007
    Posts
    5
    how do i attach an xtl file?
    Reply With QuoteRegister To Reply
  6. 11-26-2007, 05:53 PM #6
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You have to attach an .xls file which is zipped.

    Once you zip the file you click the paperclip icon in the forum's reply window. Then browse for you file and click Upload and close
    Reply With QuoteRegister To Reply
  7. 11-26-2007, 06:03 PM #7
    PatrickB
    PatrickB is offline
    Registered User
    Join Date
    11-26-2007
    Posts
    5
    can i email it to you? im at work and i dunno how to zip it its a basic comp and i cant download winzip i can go thru email tho!
    Reply With QuoteRegister To Reply
  8. 11-27-2007, 09:34 AM #8
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Can you detail here how exactly your data is layed out...

    What is the sheet name the data is on?
    What Ranges have what information?
    What you want to do? and what is an example of the expected results?
    Reply With QuoteRegister To Reply
  9. 11-27-2007, 01:36 PM #9
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    This should work for you... all you need to do is change the sheet name (where I have 'Sheet1' to whatever your sheet name is where the data inputs are occurring.

    Also, in your summary sheet...A2 is where I assume the first product name is that you want to summarize.

    =Sumif('Sheet1'!F:F,A2,'Sheet1'!E:E)
    Reply With QuoteRegister To Reply
  10. 11-27-2007, 01:56 PM #10
    PatrickB
    PatrickB is offline
    Registered User
    Join Date
    11-26-2007
    Posts
    5
    Oh my gosh it worked thank you soo much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1