+ Reply to Thread
Results 1 to 3 of 3

How do I create a conditional running total on separate work sheets?

  1. #1
    Registered User
    Join Date
    05-31-2007
    Posts
    2

    How do I create a conditional running total on separate work sheets?

    I'm not totally sure that it's possible to do this but, I can't find anything specific that tells me how.

    I want to create a running total on a separate worksheet that will sum the numbers from certains cells only if a string in a cell is equal to it.

    For example:
    Sheet 1

    A1 A5

    0101 $10.00
    0102 $12.00
    0103 $13.00
    0101 $15.00

    So on the total sheet I would want it to recognize the A1 strings and then run a total of all of A5's even if I were to all new numbers to the total.

    For example:
    Sheet 2

    A1 A5
    0101 $25.00
    0102 $12.00
    0103 $13.00


    Sorry if I'm not being clear, I'm trying my best explain what I'm trying to do.

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    Try using the SUMIF formula

    =SUMIF(Sheet1!$A$1:$A$100,"0101",Sheet1!$B$1:$B$100)

  3. #3
    Registered User
    Join Date
    05-31-2007
    Posts
    2
    Thanks, I'll give it a try.

+ 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