Lakshmi Narain Member Nov 20, 2014 #1 Dear All, Anybody help me with average IF, It showing wrong Value. PFA of sample data Attachments average if.xlsx 10.9 KB · Views: 10
Asheesh Excel Ninja Nov 20, 2014 #2 Hi Lakshmi - Use the below formula in J2 and drag it down as you need... AVERAGE(IF($A$2:$A$19=$I2,$B$2:$E$19)) Acknowledge the formula with CTRL + SHIFT + ENTER
Hi Lakshmi - Use the below formula in J2 and drag it down as you need... AVERAGE(IF($A$2:$A$19=$I2,$B$2:$E$19)) Acknowledge the formula with CTRL + SHIFT + ENTER
Lakshmi Narain Member Nov 20, 2014 #3 T Asheesh said: Hi Lakshmi - Use the below formula in J2 and drag it down as you need... AVERAGE(IF($A$2:$A$19=$I2,$B$2:$E$19)) Acknowledge the formula with CTRL + SHIFT + ENTER Click to expand... Thank You Very Much Asheesh!!
T Asheesh said: Hi Lakshmi - Use the below formula in J2 and drag it down as you need... AVERAGE(IF($A$2:$A$19=$I2,$B$2:$E$19)) Acknowledge the formula with CTRL + SHIFT + ENTER Click to expand... Thank You Very Much Asheesh!!
