newbie question with continuous loop

[newbiewexcel]

=IF((OR(C8="v",C8="vu")),B8,0)+IF((OR(F8="v",F8="vu")),E8,0)+IF((OR(I8="v",I8="vu")),H8,0)

how to put that in vba.

example: smaller vrsion
a b
1 8 v
2 8 v
3 8 s
4 8 s
5 8 v
6 8 s
7 8 v
8 32

in this case there is four's v, i want to display total 32 on cell a8.
so i guess i need to use the .find and .findnext to loop through column b to find "v", but i dont know how to continuouslly loop through without rerun the marco again.

[RMaia]

Hello Newbiewexcel,

I donīt know if I understand correctly but... why do not you use the formula "SUMIF" or "SUMIFS?

Ex:
=SUMIF(B1:B7,"v",A1:A7) = 32

Hugs.

[FDibbins]

Hi and welcome to the forum

why not just use a sumif()?

=SUMIF($B$1:$B$7,"v",$A$1:$A$7)