Multiplication question

S

Schizoid Man

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
 
S

Schizoid Man

Andy said:
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)
Click to expand...

Hi Andy,

That did the trick. Thanks a ton.
 
D

Dana DeLouis

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. :>)
 
B

Biff

Well, duh! <g>

Isn't it interesting how we often get "steered" in one direction by reading
a post?

Biff
 
S

Schizoid Man

Dana said:
As a little side note,
5*a + 5*b + 5*c

is equal to 5*(a+b+c)
or = M5*SUM(D5:D20)
Click to expand...

OMG!!

I never realized that staring at Excel sheets could make one forget
basic arithmetic!

Hahaha. :)
 
Top