PinMaster,
Your formula seems to be getting me closer to something - at least its
showing a zero in the field.

If nothing else, this tells me excel CAN do this, I just need some fine
tuning to the formula is all. Any ideas as to why it would come up as
zero? I put the formula in exactly as you showed:

=SUM(IF(RIGHT(B1:B10,1)="v",--LEFT(B1:B10,LEN(B1:B10)-1)))


--
Donna123
------------------------------------------------------------------------
Donna123's Profile: http://www.excelforum.com/member.php...o&userid=26962
View this thread: http://www.excelforum.com/showthread...hreadid=495940