problem with a formula
 

good day all, i have this formual in cell a1 =sumif(r2:r25,"steve",x2:x25)
cells r2:r25 have a data drop down list that i choose the names from.i have
to remove the validation to make the formual work.is there a way to make this
work using the validation list? any input is appreciated.
thx wynb
--
wynb

Hi!

That should work.

There has to be a problem with your list source. Is the source a range of
cells? Check those cells for unseen characters like extra spaces.

Try this:

Select "steve" from the drop down.

Then enter this formula somewhe

=LEN(A1)

Should return 5.

Test the source cell for "steve" against the selected "steve" in A1:

=A1=AA1

Biff

"WYN" wrote in message
...
good day all, i have this formual in cell a1 =sumif(r2:r25,"steve",x2:x25)
cells r2:r25 have a data drop down list that i choose the names from.i
have
to remove the validation to make the formual work.is there a way to make
this
work using the validation list? any input is appreciated.
thx wynb
--
wynb