SOLVED

After an IF statement , making 1 or 0, I need to add up only certain rows to get the total 1 count

Copper Contributor

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

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@bdog2021 

In G2:

=IF(ISTEXT(A2),0,IF(ISTEXT(A1),SUM(OFFSET(F2,0,0,MATCH(TRUE,INDEX(E2:E$1000="",),0),1)),G1))

Fill down.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@bdog2021 

In G2:

=IF(ISTEXT(A2),0,IF(ISTEXT(A1),SUM(OFFSET(F2,0,0,MATCH(TRUE,INDEX(E2:E$1000="",),0),1)),G1))

Fill down.

View solution in original post