VBE313
Well-known Member
- Joined
- Mar 22, 2019
- Messages
- 686
- Office Version
- 365
- Platform
- Windows
Is there a UDF that someone can think of that can sum the column "A" UNTIL column "B" says "Yes" again and put the formula in column C?
I have seen similar UDFs but I cannot wrap my head around this one.
<colgroup><col span="3"></colgroup><tbody>
</tbody>
I have seen similar UDFs but I cannot wrap my head around this one.
Yes | $ 1.76 | |
$ 0.76 | ||
$ 0.12 | ||
$ 0.76 | ||
$ 0.12 | ||
$ 0.01 | ||
$ - | Yes | $ 3.28 |
$ - | ||
$ 0.76 | ||
$ 0.12 | ||
$ 2.28 | ||
$ 0.12 | ||
$ 0.01 | ||
$ - | Yes | $ 1.76 |
$ - | ||
$ 0.76 | ||
$ 0.12 | ||
$ 0.76 | ||
$ 0.12 | ||
$ 0.01 | ||
$ - | Yes | $ 3.28 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>