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?