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
>
> --
>
H
Sent: Monday, October 21, 2013 2:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Counting Nos formula
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
--
Are yo
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