sum up column until dropdown is true

[ddnndd1234]

In column A i have a list of numbers, in column c there is a drop down of true and false. If the cell is true I would like the numbers at that cell and above to add up until the previous true cell in column B. The sum will be in column b beside the "true" cell. If false column stays blank

 

[Kaper]

Assuming your data is in columns A:C and starts in row 2 (row1 contains header) the formula for B2 (and copied down):

=IF(C2,SUM(A$2:A2)-SUM(B$1:B1),"")

(on screenshot there are semicolons in formula, but you probably need commas as separator (most of the world does).

 

[Jeffrey Mahoney]

Please try this

Book2
	A	B	C
2	1		FALSE
3	2		FALSE
4	3	6	TRUE
5	4		FALSE
6	5		FALSE
7	6		FALSE
8	7		FALSE
9	8		FALSE
10	9	39	TRUE
11	10		FALSE
12	11		FALSE
13	12		FALSE
14	13		FALSE
15	14		FALSE
16	15		FALSE
17	16		FALSE
18	17		FALSE
19	18		FALSE
20	19	145	TRUE
Sheet7

Cell Formulas
Range	Formula
B2	B2	=IF(C2=TRUE,SUM(TAKE(A$2:A2,-(ROWS(A$2:A2)-IFERROR(XMATCH(TRUE,C1:C$2,0,-1),0)))),"")
B3:B20	B3	=IF(C3=TRUE,SUM(TAKE(A$2:A3,-(ROWS(A$2:A3)-IFERROR(XMATCH(TRUE,C$2:C2,0,-1),0)))),"")

Cells with Data Validation
Cell	Allow	Criteria
C2:C20	List	True,False

 

[ddnndd1234]

Assuming your data is in columns A:C and starts in row 2 (row1 contains header) the formula for B2 (and copied down):

=IF(C2,SUM(A$2:A2)-SUM(B$1:B1),"")

(on screenshot there are semicolons in formula, but you probably need commas as separator (most of the world does).

View attachment 117671

You're a saint and a scholar, this works in excel. Now, you wouldn't know how to do this is google sheets as well?

 

[ddnndd1234]

Please try this

Book2
	A	B	C
2	1		FALSE
3	2		FALSE
4	3	6	TRUE
5	4		FALSE
6	5		FALSE
7	6		FALSE
8	7		FALSE
9	8		FALSE
10	9	39	TRUE
11	10		FALSE
12	11		FALSE
13	12		FALSE
14	13		FALSE
15	14		FALSE
16	15		FALSE
17	16		FALSE
18	17		FALSE
19	18		FALSE
20	19	145	TRUE
Sheet7

Cell Formulas
Range	Formula
B2	B2	=IF(C2=TRUE,SUM(TAKE(A$2:A2,-(ROWS(A$2:A2)-IFERROR(XMATCH(TRUE,C1:C$2,0,-1),0)))),"")
B3:B20	B3	=IF(C3=TRUE,SUM(TAKE(A$2:A3,-(ROWS(A$2:A3)-IFERROR(XMATCH(TRUE,C$2:C2,0,-1),0)))),"")

Cells with Data Validation
Cell	Allow	Criteria
C2:C20	List	True,False

I could not get this to work, I got #NAME?

 

[ddnndd1234]

You're a saint and a scholar, this works in excel. Now, you wouldn't know how to do this is google sheets as well?

Never Mind it works in Sheets too. Thanks

 

[Kaper]

You've not mentioned G.Sheets in first post, neither in profile.
So both answers were formated for Excel.
Jefrey's formula use TAKE function, which is available only in Excel 365 as I remember

 

[Jeffrey Mahoney]

You've not mentioned G.Sheets in first post, neither in profile.

And it was posted in Excel Questions Forum