Sum the result of column times column by row...

[sfluegge]

I could think of no better way to describe this one...

I have a spreadsheet that has a list of parts, prices and quantities. I want to provide an invoice total at the top of my entry worksheet. I know I could create a hidden column and do the price*quantity then provide a sum of that column for my worksheet but I was hoping there was a more elegant way of writing all that into a single cell formula...

Can I accomplish this in one stroke?

Thanks!

[Søren Larsen]

Try =SUMPRODUCT("your array with quantities","your array with price")

[icestationzbra]

yes, it is very much possible, depending on the structure of your worksheet. care to upload a sample?

[sfluegge]

Soren, that worked for me, thanks! I thought by title sumproduct might do it but then when they listed it as arrays I was afraid it would sum the two arrays seperately and then sum that combined total. I didn't understand the operator (*) was assumed in the function!

Thanks a bunch, now my worksheet can remain elegant!

[sfluegge]

Thanks Icestationzbra. I got it working with Soren's comments.

[Søren Larsen]

Yes, it's the "sum of the products". And no problem.