# UDF to sum until certain column is not blank again

#### VBE313

##### Well-known Member
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.
 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>

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Rick Rothstein

##### MrExcel MVP
I am not sure why, but you example totals each are \$0.01 too small. Anyway, give the following UDF a try...
Code:
``````Function SumToYes()
Dim R As Long
R = Application.Caller.Row + 1
Do While Cells(R, "B").Value <> "Yes"
SumToYes = SumToYes + Val(Cells(R, "A").Value)
R = R + 1
Loop
End Function``````

#### VBE313

##### Well-known Member
Hi Rick,

Thank you for this UDF! I am very new to UDFs, so how how i type this in the cell?

Thanks!

#### VBE313

##### Well-known Member
Hi Rick,

i just entered that with nothing else in it and it worked.

Thank you so much!