problem with a formula

[Guest]

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

 

[Biff]

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 somewhere:

=LEN(A1)

Should return 5.

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

=A1=AA1

Biff