Thanks its working fine :)
On Sun, Feb 2, 2014 at 1:33 PM, Swapnil Palande wrote:
> 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={
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, Chandr
Hi,
am getting incorrect answer.
Regards,
Chandru
On Fri, Jan 31, 2014 at 5:03 PM, Aamir Shahzad wrote:
> 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,
>>
>>
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
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 @
https://www.facebook.com/disc
