Multiplication question Schizoid Man <schiz[ at ]sf.com> 28.08.2006 20:17:37 Hi, I have a row of numbers that I need to multiply by a single constant and then sum over. I thought I could use a sumproduct formula like SUMPRODUCT(D5:D20,$M$5:$M$5), but unfortunately this does not do the trick. Can I do this without a UDF? Thanks, Schiz

Re: Multiplication question "Andy Wiggins" <contact me via my website at www.BygSoftware.com> 28.08.2006 20:36:28 Your problem wasn't that clear to me in what you were trying to achieve - some sample numbers might help, However, in the meantime, try this variation ... =SUMPRODUCT(D5:D20*$M$5) -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Schizoid Man" <schiz[ at ]sf.com> wrote in message news:ecvj1a$9vu$1[ at ]geraldo.cc.utexas.edu... [Quoted Text] > Hi, > > I have a row of numbers that I need to multiply by a single constant and > then sum over. > > I thought I could use a sumproduct formula like > SUMPRODUCT(D5:D20,$M$5:$M$5), but unfortunately this does not do the > trick. > > Can I do this without a UDF? > > Thanks, > Schiz

Re: Multiplication question "Biff" <biffinpitt[ at ]comcast.net> 28.08.2006 20:41:22 Try it like this: =SUMPRODUCT(D5:D20*$M$5) Biff "Schizoid Man" <schiz[ at ]sf.com> wrote in message news:ecvj1a$9vu$1[ at ]geraldo.cc.utexas.edu... [Quoted Text] > Hi, > > I have a row of numbers that I need to multiply by a single constant and > then sum over. > > I thought I could use a sumproduct formula like > SUMPRODUCT(D5:D20,$M$5:$M$5), but unfortunately this does not do the > trick. > > Can I do this without a UDF? > > Thanks, > Schiz

Re: Multiplication question Schizoid Man <schiz[ at ]sf.com> 28.08.2006 20:42:56 Andy Wiggins wrote: [Quoted Text] > Your problem wasn't that clear to me in what you were trying to achieve - > some sample numbers might help, > However, in the meantime, try this variation ... > =SUMPRODUCT(D5:D20*$M$5) Hi Andy, That did the trick. Thanks a ton.

Re: Multiplication question "Dana DeLouis" <ddelouis[ at ]bellsouth.net> 28.08.2006 21:18:06 As a little side note, 5*a + 5*b + 5*c is equal to 5*(a+b+c) or = M5*SUM(D5:D20) But SUMPRODUCT works just as nice. :>) -- HTH. :>) Dana DeLouis Windows XP, Office 2003 "Schizoid Man" <schiz[ at ]sf.com> wrote in message news:ecvkgp$aj8$1[ at ]geraldo.cc.utexas.edu... [Quoted Text] > Andy Wiggins wrote: >> Your problem wasn't that clear to me in what you were trying to achieve - >> some sample numbers might help, >> However, in the meantime, try this variation ... >> =SUMPRODUCT(D5:D20*$M$5) > > Hi Andy, > > That did the trick. Thanks a ton.

Re: Multiplication question "Biff" <biffinpitt[ at ]comcast.net> 28.08.2006 21:53:50 Well, duh! <g> Isn't it interesting how we often get "steered" in one direction by reading a post? Biff "Dana DeLouis" <ddelouis[ at ]bellsouth.net> wrote in message news:uzdZ7duyGHA.476[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > As a little side note, > 5*a + 5*b + 5*c > > is equal to 5*(a+b+c) > or = M5*SUM(D5:D20) > > But SUMPRODUCT works just as nice. :>) > -- > HTH. :>) > Dana DeLouis > Windows XP, Office 2003 > > > "Schizoid Man" <schiz[ at ]sf.com> wrote in message > news:ecvkgp$aj8$1[ at ]geraldo.cc.utexas.edu... >> Andy Wiggins wrote: >>> Your problem wasn't that clear to me in what you were trying to >>> achieve - some sample numbers might help, >>> However, in the meantime, try this variation ... >>> =SUMPRODUCT(D5:D20*$M$5) >> >> Hi Andy, >> >> That did the trick. Thanks a ton. > >

Re: Multiplication question Schizoid Man <schiz[ at ]sf.com> 28.08.2006 21:59:54 Dana DeLouis wrote: [Quoted Text] > As a little side note, > 5*a + 5*b + 5*c > > is equal to 5*(a+b+c) > or = M5*SUM(D5:D20) OMG!! I never realized that staring at Excel sheets could make one forget basic arithmetic! Hahaha. :)