Hi prabhakar,
Please find the attachment.
Regards,
Ganesh N
On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote:
> Hi Team,
>
> need your help to get nos by using formula. I know how to get details
> through pivot table but wanted to know formula also. Pls help.
>
> Rgds,
> Prabhakar
>
> --
>
Use this for equal
=SUMPRODUCT((F9=$A$2:$A$241)*(F9=$B$2:$B$241))
And use this for not equal
=SUMPRODUCT((F9=$A$2:$A$241)*(F9<>$B$2:$B$241))
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent: Monday
Hi Prabhakar ,
Use this array formula- =SUMPRODUCT(--($F9=$A$2:$A$241)*($C$2:$C$241=G$8))
i have learnt it from this experts only.
With warm regards,
Rajan Sharma
On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote:
> Hi Team,
>
> need your help to get nos by using formula. I know how t
