+ Reply to Thread
Results 1 to 2 of 2

Adding cells that fit criteria

  1. #1
    Registered User
    Join Date
    11-19-2008
    Location
    Texas
    Posts
    2

    Adding cells that fit criteria

    I've been stumped on this problem for about a day now and couldn't think of anywhere else to turn. Here's my dilema:

    1 2 3
    A 75 75 75
    B 75 50 50
    C 40 50 50
    D 25 ^
    E
    F 25 50 50
    G 75 ^
    H 0 ^
    I 10 ^

    I want to pull data from column 1 to column 3 based on column 2. Column 3 can be < or = to column 2 in the same row. This part is easy and I've figured that out.

    Here's the trick, if column 2 has "^" in it, I want the sum of the number above and all data in "^" rows below it. (EX: F3 = (Sum (F1:I1) < F2)) So even though the sum is 110, F3 displays 50. Same with cell C3. I've tried using Sumif, Countif, but can't get creative enough.

    The problem is how do I keep the sums of C3 and F3 seperate? Is there some sort of stop summing or counting function I can use to sum only the cells directly below the number with the "^".

    Thanks in advance,

    Tyson

  2. #2
    Registered User
    Join Date
    11-19-2008
    Location
    Texas
    Posts
    2
    ^^^bump^^^

+ 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