Y yaelcohen Member Mar 30, 2016 #1 Hello Expert, I attached a file with my question as tried to make an average for the columns but there is a problem Please help and thanks a lot!!! Attachments Question 20.xlsb Question 20.xlsb 8.6 KB · Views: 5
Hello Expert, I attached a file with my question as tried to make an average for the columns but there is a problem Please help and thanks a lot!!!
N NARAYANK991 Excel Ninja Mar 30, 2016 #2 Hi , I am not able to understand how you want to calculate the average. Going by the conditions which need to be satisfied , only the first two rows of data qualify to be used for the calculations. Now , what is the definition of average here ? 1. AVERAGE((E3 / (F3 + G3)) + (E4 / (F4 + G4))) 2. (E3 + E4) / (F3 + G3 + F4 + G4) Narayan
Hi , I am not able to understand how you want to calculate the average. Going by the conditions which need to be satisfied , only the first two rows of data qualify to be used for the calculations. Now , what is the definition of average here ? 1. AVERAGE((E3 / (F3 + G3)) + (E4 / (F4 + G4))) 2. (E3 + E4) / (F3 + G3 + F4 + G4) Narayan
Y yaelcohen Member Mar 30, 2016 #3 OK, I am sorry I was not clear enough. The formula for the average is as you mentioned above: AVERAGE((E3 / (F3 + G3)) + (E4 / (F4 + G4))) You are right and this is my mistake, only the first two rows should actually taken into account. Thanks a lot! Attachments Question 20.xlsb Question 20.xlsb 8.6 KB · Views: 4
OK, I am sorry I was not clear enough. The formula for the average is as you mentioned above: AVERAGE((E3 / (F3 + G3)) + (E4 / (F4 + G4))) You are right and this is my mistake, only the first two rows should actually taken into account. Thanks a lot!
N Naresh Yadav Active Member Mar 30, 2016 #4 Dear Yaelcohen, pls try this one and complete the formula with CTRL+SHIFT+ENTER =AVERAGE(E3:E8/(F3:F8+G3:G8))
Dear Yaelcohen, pls try this one and complete the formula with CTRL+SHIFT+ENTER =AVERAGE(E3:E8/(F3:F8+G3:G8))
N Naresh Yadav Active Member Mar 30, 2016 #5 and the second option for the firms that are good and in growth.. complete the formula with CTRL+SHIFT+ENTER at the end.. =AVERAGE(IF(C3:C8="Y",IF(D3:D8="Y",E3:E8/(F3:F8+G3:G8))))
and the second option for the firms that are good and in growth.. complete the formula with CTRL+SHIFT+ENTER at the end.. =AVERAGE(IF(C3:C8="Y",IF(D3:D8="Y",E3:E8/(F3:F8+G3:G8))))
