"Stan Brown" wrote:
Stan Brown;1214641 Wrote:
=sumproduct( 0+right($N8:$EP8,1)="V") )
[....]
I don't know what you mean by "error in value"
[....]
,
Try copy-pasting instead of retyping.

Perhaps you should try following your own advice. It might surprise you.

No matter. This approach is unnecessarily complicated.

Amanda, see the equivalent COUNTIF solution that I provided.