| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add 3 column (of YES) to give a total % complete
I am trying to write a formula that will allow me to add a Yes to one cell
(in 3 different columns) cell and then give a % as the answer For example: Cell A1 = Yes Total would be 40% Cell A2 = Yes Combined (A1+A2) Total would be 70% Cell A3 = Yes Combined (A1+A2+A3) Total would be 100% Any and all help is appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If the total = between 17-20 give it a score of 5, and so on | Excel Discussion (Misc queries) | |||
| want a formula give total quanitity break up frm other sheet | Excel Worksheet Functions | |||
| Variance Total for less than complete year? | Excel Discussion (Misc queries) | |||
| How do I total a column which was created using the MID function? | Excel Worksheet Functions | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Threaded Mode
