Re: $$Excel-Macros$$ Need help on sumproduct function

2012-02-15 Thread Maries
http://www.meadinkent.co.uk/xlwtdavg.htm On Wed, Feb 15, 2012 at 9:04 PM, Sam Mathai Chacko wrote: > You have to be a little more clear. '"Average" columns values using > remaining column values' doesn't ring a bell. > > Maybe post an expected output to make your requirement clear. > > Sam > > >

Re: $$Excel-Macros$$ Need help on sumproduct function

2012-02-15 Thread Sam Mathai Chacko
You have to be a little more clear. '"Average" columns values using remaining column values' doesn't ring a bell. Maybe post an expected output to make your requirement clear. Sam On Wed, Feb 15, 2012 at 1:40 AM, KAMASANI RAJESH BABU < kamasaniraj...@gmail.com> wrote: > Hi Team, > > Need help o

$$Excel-Macros$$ Need help on sumproduct function

2012-02-15 Thread KAMASANI RAJESH BABU
Hi Team, Need help on "Sumproduct" funtion. Below is the description., A b c d e f g Average Q4 12% 54% 55% 20% 19% 53% 68% 37% Q1 5% 22% 67% 20% 39% 21% 62% 37% Q2 7% 31