Create Formula for Weighted Average in non-consecutive cells

F

ferne

I have a spreadsheet which across the top has the months Jan to Dec and
Total. Under each month is 4 categories Days/oil/gas and would like to
simplify a formula for a weighted avg. eg.

A B C D E F G H I
JANUARY FEBRUARY MARCH etc. to December
days Oil gas days Oil Gas days Oil Gas
6 22 13 4 5 18 7 12 15

formula: =(a1*b1+d1*e1+g1*h1)/(a1+e1+g1)

Is there any way to simplity this. Thanks for any help anyone can give.
ferne
 

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

Similar Threads

Simplify Weighted Average Formula 4
help with 12 week rolling average 3
Taking Average ignoring #DIV/0! in the range... 1
Count non-consecutive cells..... 7
looking for a solution 1
creating nested formulas from drop down box 5
How do i average only certain cells 5
Getting a Result in vlookup dependent on another formula 1

Top