Or, you could just use the * wildcard.
=SUMIF(A17:W17,"*V*",A17:W17)

I think you misundstood what they want.

A17 = 2V
B17 = 4V
C17 = 1V
D17 = 3S
E17 = 8S

=SUMIF(A17:W17,"*V*",A17:W17) returns 0

Array entered:

=SUM(IF(RIGHT(A17:W17)="V",--SUBSTITUTE(A17:W17,"V","")))

Returns 6

--
Biff
Microsoft Excel MVP


"Elkar" wrote in message
...
Or, you could just use the * wildcard.

=SUMIF(A17:W17,"*V*",A17:W17)

HTH
Elkar


"T. Valko" wrote:

Try this array formula** :

=SUM(IF(RIGHT(A17:W17)="V",--SUBSTITUTE(A17:W17,"V","")))

Assumes that every cell that contains a V also contains a number.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Kathryn" wrote in message
...
I want to use sumif on a row cells containing something like 2V, 4V, 1V,
3S,
8S, etc. I want to add the cells that have V in them.
I have tried using =SUMIF(A17:W17,"V",A17:W17) but it doesn't seem to
work.
I'm wondering if the sum range is bothered by the letters in the cells
(V
or
S).