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
Bookmarks