Hi i have a question. I have a drop down list. Yes are no.

When I say is must make a sum. If I say no it must count Notting. I need to have a total sum

For example.

I have c1 til c5 numbers. C6 I have the total sum and In d1 til d5 I have drop down list yes are no.

In d6 I like to have the sum of all yes but if it says no the sum must not countIs there any hope

Hi thanks, I try it but I get a formula error, it is something of example 2

Since I can't see your spreadsheet from where I'm sitting, telling me that you get a "formula error" doesn't give me much to work with. Perhaps if you posted the formula that you have tried as well as the error, I could offer some more assistance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History