Thanks its working fine :)
On Sun, Feb 2, 2014 at 1:33 PM, Swapnil Palande palande.swapni...@gmail.com
wrote:
Hi,
Try these below mentioned formulas
=SUMPRODUCT(((--(A1:A4={a,b})*B1:B4)) / (COUNTIF(A1:A4, a) +
COUNTIF(A1:A4, b)))
OR
Hi,
Try these below mentioned formulas
=SUMPRODUCT(((--(A1:A4={a,b})*B1:B4)) / (COUNTIF(A1:A4, a) +
COUNTIF(A1:A4, b)))
OR
=SUMPRODUCT((--(A1:A4={a,b})*B1:B4))/SUMPRODUCT(--(A1:A4={a,b}))
Hope this is what you want.
Regards,
Swapnil.
On Fri, Jan 31, 2014 at 8:04 PM, Chandra Shekar
Hello,
Could you please help me in attached file to find average using sumproduct.
Thanks in advance.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Try this
=SUMPRODUCT(($A$1:$A$4=A1)*($B$1:$B$4)/COUNTIF($A$1:$A$4,A1))
On Fri, Jan 31, 2014 at 3:33 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
Could you please help me in attached file to find average using sumproduct.
Thanks in advance.
Regards,
Chandru
--
Are
Hi,
am getting incorrect answer.
Regards,
Chandru
On Fri, Jan 31, 2014 at 5:03 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Try this
=SUMPRODUCT(($A$1:$A$4=A1)*($B$1:$B$4)/COUNTIF($A$1:$A$4,A1))
On Fri, Jan 31, 2014 at 3:33 PM, Chandra Shekar
chandrashekarb@gmail.com wrote: