Long Formula...Can it be shortened

K

kaveman

I need a formula that takes a price as an absolute reference and the
multiplies this by the amount of pieces ordered to give a total. I
would look something like this: =$a$1*a3+$b$1*b3+...+$bl$1*bl3. I
there a better way of doing this so I don't have to type out all thes
values
 
K

Ken Wright

=SUMPRODUCT(($A$1:$BL$1)*(A3:BL3)) and then copy down if you have numerous rows
of data like this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top