Formula for counting and dividing

P

Preschool Mike

Here's my example. Cells A1:H1 have + (plus sign: goal met) and - (minus
sign: goal not met) in them and some cells in the same row have nothing if
the goal was not ran that day. I need a formula that counts the number of +
signs and - signs (a total of the two: adding + and - together) and then it
divides the number of + signs by the answer. Any help is appreciated. I'd
like to have the answer in the format of percentage or fraction. I'm using
excel 2007 and the cell containing the answer are merged (will they need to
be unmerged?).

Thanks,
Mike
 
S

Sean Timmons

They would need to be unmerged first...

=Countif(A1:H1,"+")/counta(A1:H1)

This assumes those that have nothing truly are blank.

Otherwise:

=Countif(A1:H1,"+")/(Countif(A1:H1,"+")+Countif(A1:H1,"-"))

Gets it for sure.
 
S

Sean Timmons

They would need to be unmerged first...

=Countif(A1:H1,"+")/counta(A1:H1)

This assumes those that have nothing truly are blank.

Otherwise:

=Countif(A1:H1,"+")/(Countif(A1:H1,"+")+Countif(A1:H1,"-"))

Gets it for sure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative number format 5
Using Excell , have ######### showing up in the cells. Why 1
Formula for function/argument "exclude". 0
Counting patient check in 13
counting entries within a cell's formula 8
Need a little math help in making a formula 2
Counting Merged Cells 5
Odd problem with formula counting Yes and No 5

Top