Re: $$Excel-Macros$$ TO CREATE SUMMARY

2011-11-04 Thread Sam Mathai Chacko
Another easy way to build this would be to use Pivot Tables Regards, Sam Mathai Chacko On Fri, Nov 4, 2011 at 10:43 PM, xlstime wrote: > Please find the attachment.. > > > > On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar > wrote: > >> Dear,EXCELERS >> >> On this workbook i want in summary she

Re: $$Excel-Macros$$ TO CREATE SUMMARY

2011-11-04 Thread xlstime
Please find the attachment.. On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar wrote: > Dear,EXCELERS > > On this workbook i want in summary sheet* fill total gift given > coloum*according their given dates Valus in second sheet (gift data),, by > any > formula . So please suggest any formul

Re: $$Excel-Macros$$ TO CREATE SUMMARY

2011-11-04 Thread Sam Mathai Chacko
Use in D20 =SUMPRODUCT(('GIFT DATA'!$B$9:$B$193=Summary!$C20)*('GIFT DATA'!$E$9:$E$193=Summary!D$15)*('GIFT DATA'!$F$9:$F$193)) and drag down and across Regards, Sam Mathai Chacko On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar wrote: > Dear,EXCELERS > > On this workbook i want in summary shee

$$Excel-Macros$$ TO CREATE SUMMARY

2011-11-04 Thread rvsingh parmar
Dear,EXCELERS On this workbook i want in summary sheet* fill total gift given coloum*according their given dates Valus in second sheet (gift data),, by any formula . So please suggest any formula for this problem. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, ac