Be seen. Boost your question’s priority for more expert views and faster solutions

I have a defined list titled sawlist and in that list are the letters i.e. W and in the next cell down L and so on. I wrote a formula that is su=sum(if(sawlist=B9,B10))

I get a #value answer. My list is not numbers but letters and I am trying to write a letter in one cell and have the formula identify it as true if it matches a letter in another cell. How can I write this formula?

Thnaks Bill

I get a #value answer. My list is not numbers but letters and I am trying to write a letter in one cell and have the formula identify it as true if it matches a letter in another cell. How can I write this formula?

Thnaks Bill

Not entirely sure what you are after could you provide an file.

Note to compare two cells regardless if they are letters you can use something like

=IF(A1=B1, TRUE, FALSE)

Michael

=SUM(IF(AND($EU20="W",$CG2

My list contaings all the letters i.e. "W" & "col" I use on "" marks just the letters and I would like to take the short cut that would allow me to to have say $EU20 = any of the letters in the saw list and without creating a much more difficult formula. In this formula I would have a number of different defined lists. Is this polssible?

Thanks Bill

I'm trying to make sense of your formula, but I'm not getting far. Can you post a spreadsheet with a simplified example that shows where your "sawlist" is and how you would want to involve that in a formula?

Once we get the general principles nailed, it may be easier to tackle the beast.

cheers, teylyn

=IF(AND($EU20="W",$CG20<>0

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

try

=IF(ISNA(MATCH(B2,sawlist,

replace "no match" and "match" with what you want to happen. I did not quite understand the "sum" in that formula.

cheers, teylyn