Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem Formula | Excel Discussion (Misc queries) | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |