Hey everyone!

I'm an excel noob trying to get by in the world.

I have A1-A9 with dropdown lists. The choices in the list are yes and no.

I'd love to assign yes and no a vaule (1,0) and sum this on A10.

Any ideas how?

Thanks so much!