Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

2012-01-08 Thread Lokesh Loki
Hi Sam, Thanks for solving the problem. All the best for your future. Once again thanks a lot. Regards Lokesh.M On Sun, Jan 8, 2012 at 11:56 PM, Sam Mathai Chacko wrote: > To add it to the sumproduct formula, all you had to do was ensure that the > correct sheet and the correct cells are being

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

2012-01-08 Thread Lokesh Loki
Hi Sam, I have checked this formula and i get the correct counts. and just add these counts to your sumproduct formula based on name wise. Thanks for solving the problem. Regards Lokesh On Sun, Jan 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote: > Here's the formula as an array. > > > =IF(ISERRO

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

2012-01-08 Thread Lokesh Loki
Hi sam, thanks for your valuable reply, Yes. i am looking deleted sheet count ANUSHA CHANNAPPA get 54 is to be added in consolidated report cell F4. regards lokesh On Sun, Jan 8, 2012 at 9:12 PM, Sam Mathai Chacko wrote: > Lokesh, your request is not very clear. Can you please explain what > ex

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

2012-01-08 Thread Sam Mathai Chacko
Lokesh, your request is not very clear. Can you please explain what exactly are you wanting to do? For example, how did ANUSHA CHANNAPPA get 54 counts??!! Sam On Sun, Jan 8, 2012 at 8:37 PM, lokesh wrote: > Hi Experts, > > I am looking any updates from you. Please do the needful. > > Regards >

$$Excel-Macros$$ Fwd: Add counts in sumproduct

2012-01-08 Thread lokesh
Hi Experts, I am looking any updates from you. Please do the needful. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki Date: Jan 8, 7:22 pm Subject: Add counts in sumproduct To: MS EXCEL AND VBA MACROS Hi All, Please find the attached excel file. And I need to add