Thanks everyone for helping me with my questions. Also, Lars-Åke Aspelin,
thanks for the information on changing the commas. That will help me on
another spreadsheet where I have several values that I need totaled up.



"Lars-Åke Aspelin" wrote:

On Thu, 10 Dec 2009 10:20:02 -0800, john_8000
wrote:

I'm creating a row with drop-down lists with text.I want to create a simple
drop-down list with yes and no. Yes would have a background (unseen) value
of 1and no would have a value of 0. After items were selected from the
drop-down list, I want the unseen value totaled to the far right of the page.
I found the following formula which works for columns, but when I try to
change the cell range to a row of cells, I get "#N/A".


=SUMPRODUCT((C3:C23={"Yes","No"})*({1,0}))

Thanks for any assistance.


You have to change the commas to semicolons, like this

=SUMPRODUCT((A1:J1={"Yes";"No"})*({1;0}))

Hope this helps / Lars-Åke
.