Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for counting and dividing
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for counting and dividing
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. "Preschool Mike" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT: dividing the formula of one cell by another. | Excel Worksheet Functions | |||
What is the formula for dividing-I have the total | Excel Worksheet Functions | |||
Need formula for dividing by "number of entries" in a column or row | Excel Discussion (Misc queries) | |||
Formula needed for dividing hours by numbers | Excel Discussion (Misc queries) | |||
What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions |