Functions-d would rather copy and paste formulas

[dale1948]

I have 2 columns of data. 1st column is quantity, the 2nd is unit selling
price. Without adding a 3rd column for extended price, I'd like to write a
formula that will give me the average selling price for the total of the
quantity column. You could call this the weighted average. I have to do this
for a number of different sets of data, and would rather copy and paste
formulas, if possible.

Thanks for your help!

Dale

[Tim C]

On way:

=SUMPRODUCT(--A1:A10,--B1:B10)/SUM(A1:A10)

Tim C

"dale1948" <dale1948@discussions.microsoft.com> wrote in message
news:1185C241-8AD5-4FEA-8581-CBC299E72396@microsoft.com...
>I have 2 columns of data. 1st column is quantity, the 2nd is unit selling
> price. Without adding a 3rd column for extended price, I'd like to write a
> formula that will give me the average selling price for the total of the
> quantity column. You could call this the weighted average. I have to do
> this
> for a number of different sets of data, and would rather copy and paste
> formulas, if possible.
>
> Thanks for your help!
>
> Dale

[dale1948]

Excellent!

Thank you for your help!

Dale

"Tim C" wrote:

> On way:
>
> =SUMPRODUCT(--A1:A10,--B1:B10)/SUM(A1:A10)
>
> Tim C
>
> "dale1948" <dale1948@discussions.microsoft.com> wrote in message
> news:1185C241-8AD5-4FEA-8581-CBC299E72396@microsoft.com...
> >I have 2 columns of data. 1st column is quantity, the 2nd is unit selling
> > price. Without adding a 3rd column for extended price, I'd like to write a
> > formula that will give me the average selling price for the total of the
> > quantity column. You could call this the weighted average. I have to do
> > this
> > for a number of different sets of data, and would rather copy and paste
> > formulas, if possible.
> >
> > Thanks for your help!
> >
> > Dale
>
>
>