Functions
Excellent!
Thank you for your help!
Dale
"Tim C" wrote:
On way:
=SUMPRODUCT(--A1:A10,--B1:B10)/SUM(A1:A10)
Tim C
"dale1948" wrote in message
...
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
|