Thanks for the quick response...but i want to create a function for it so that I can just highlight the range once...with the formula i use above (sum((A2:A4)*(B2:B4))/sum(B2:B4)) or your formula I have to highlight all 3 ranges separately...i want to just highlight one range (the 2 columns together) and have it do the calculation

i use this formula a lot for work, and i dont feel like highlighting long columns of data 3 separate times