any way to dynamically pick up the rows

[daveyc18]

want to pick up the values in column B beside "BC backdates", "cash adjustment," and "client fails

but only the ones below "53"(currently row 18)

want this to be dynamic as the row number can change

Loading Google Sheets

 

[Jeffrey Mahoney]

Please try this:

Main.xlsm
	A	B	C
1			6
2
3	Something	10
4	BC backdates	1
5	Other	11
6	cash adjustment	2
7	No	12
8	client fails	3
9	Maybe	13
Sheet3

Cell Formulas
Range	Formula
C1	C1	=SUM(FILTER(B1:B52,BYROW((A1:A52={"BC backdates","cash adjustment","client fails"})*(ROW(A1:A52)),LAMBDA(row,SUM(row))),""))