Hi,
My formula is in column C.
I need to count all the multi-drops, leaving out the blanks.
Once row with Column A "First Line" and Column B "Multi-Drop" are meet, restart the count.
This is the formula that i have on Column C
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">=IF(A2="First Line",C3,IF(A1="",C1,IFERROR(MATCH("First Line",A2:A1170,0),COUNTIF(B1:B3670,"Multi-Drop"))))</code>
It does the count as expected but it takes into consideration the blanks as well, and i would like it not to do so.
Any help is appreciated.
My desired results are in Column D, didn't manually input till the end.
My formula is in column C.
I need to count all the multi-drops, leaving out the blanks.
Once row with Column A "First Line" and Column B "Multi-Drop" are meet, restart the count.
This is the formula that i have on Column C
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">=IF(A2="First Line",C3,IF(A1="",C1,IFERROR(MATCH("First Line",A2:A1170,0),COUNTIF(B1:B3670,"Multi-Drop"))))</code>
It does the count as expected but it takes into consideration the blanks as well, and i would like it not to do so.
Any help is appreciated.
My desired results are in Column D, didn't manually input till the end.