Jul 03 2021 02:55 AM
I attached the file, the GOLD column is what I need it to look like, I need it to add up all of the 1s that fit in the category of the string (Sun) in a2 , and populate all of them that have the 1 to the left, and are underneath A2, then when we get to a44 (Abella) need it to start over
Jul 03 2021 04:08 AM
SolutionIn G2:
=IF(ISTEXT(A2),0,IF(ISTEXT(A1),SUM(OFFSET(F2,0,0,MATCH(TRUE,INDEX(E2:E$1000="",),0),1)),G1))
Fill down.
Jul 03 2021 06:49 AM
Jul 03 2021 04:08 AM
SolutionIn G2:
=IF(ISTEXT(A2),0,IF(ISTEXT(A1),SUM(OFFSET(F2,0,0,MATCH(TRUE,INDEX(E2:E$1000="",),0),1)),G1))
Fill down.