Re: $$Excel-Macros$$ Counting Nos formula

2013-10-21 Thread Ganesh N
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 > > -- >

RE: $$Excel-Macros$$ Counting Nos formula

2013-10-21 Thread Ravi Kumar
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

Re: $$Excel-Macros$$ Counting Nos formula

2013-10-21 Thread Rajan sharma
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