drop down excel yes no counting

October 9, 2014 at 01:11:47
Specs: Linux
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 count

Is there any hope

See More: drop down excel yes no counting

Report •

Report •

October 9, 2014 at 04:42:52
Hi thanks,

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

Report •

October 9, 2014 at 06:49:22
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.

Report •
Related Solutions

Ask Question