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
