Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-09-01 Thread Dilan De Silva
he places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > ---------- > *From:* dguillett1 > *To:* excel-macros@googlegroups.com > *Sent:* Thu, August 30, 2012 10:17:10 AM > > *Subject:* Re: $$Ex

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-08-30 Thread Paul Schreiner
From: dguillett1 To: excel-macros@googlegroups.com Sent: Thu, August 30, 2012 10:17:10 AM Subject: Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition Your method of looping is inefficient when compared to FIND. Don Guillett Microsoft Excel Developer SalesAid Software d

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-08-30 Thread dguillett1
Your method of looping is inefficient when compared to FIND. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Dilan De Silva Sent: Thursday, August 30, 2012 8:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Calculate a total

Re: $$Excel-Macros$$ Macro to Calculate a total upon a condition

2012-08-30 Thread Dilan De Silva
Dear Guillett, Thank for the solution. Your answer is perfect. I wrote below macro for the same project. However it's not working properly. I tried to put the sum formula to get the total. I think error is writing the upper cell reference(e.g:G50). Do you have any idea about getting the correct ce