$$Excel-Macros$$ Re: Nested Formula

2009-09-20 Thread Dilip Pandey
Hi Jitheesh, Actually a good query and reasonable too. Attached workbook has been solved per your requirements. Enjoy..!! Suggestion:- Do not merge the cells, just for the shake of looks. Alternatively keep the data in one cell and do a format boarder, justify etc to keep the reach and area fil

$$Excel-Macros$$ Re: Nested Formula

2009-09-12 Thread Dilip Pandey
Hi Jitu, You can use DSUM or SUMPRODUCT to solve your query. For better illustration, you should attache the sample test file. It is very simple to attach the file, just send an email to "excel-macros@googlegroups.com" and attach the file. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),B

$$Excel-Macros$$ Re: Nested Formula

2009-09-12 Thread Aindril De
Please reply to this email with the attachment On Sat, Sep 12, 2009 at 4:07 PM, Jitu <7jit...@gmail.com> wrote: > > Please let me know how can i send the excel file or where can i upload > it > > > > --~--~-~--~~~---~--~~ --