| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to add 3 column (of YES) to give a total % complete
A little different approach:
=INDEX({0;40;70;100},COUNTIF(D15:F15,"Yes")+1) This assumes your "yeses" go in columns D, E, and F and that you want a 0 if there are none. Good luck Ken Norfolk, Va On Jun 30, 2:37*pm, Eduardo wrote: Hi, try =IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",*IF(a1="YES","40%",""))) "preyesone" wrote: 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!- Hide quoted text - - Show quoted text - |
| 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
