# Thread: UDF to sum until certain column is not blank again Thanks:  1 Post #5294206 (1) Likes:  1 Post #5294206 (1)

1. ## UDF to sum until certain column is not blank again

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

2. ## Re: UDF to sum until certain column is not blank again

https://superuser.com/questions/1248...ndition-is-met

This is the only URL that somewhat helped me understand. But this goes through columns not rows, my "Yes" can also be 0 if need be.

Thanks

3. ## Re: UDF to sum until certain column is not blank again

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```

4. ## Re: UDF to sum until certain column is not blank again

Hi Rick,

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

Thanks!

5. ## Re: UDF to sum until certain column is not blank again

Hi Rick,

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

Thank you so much!