CODEWITHSUNDEEP
vbaexceloptimizationexcel-formula
G. Dimitriou
G. Dimitriou

Reputation: 67

Calculating the average percentage of a bunch of figures in Excel?

Basically, I'm trying to calculate the total average outage hours of a worksheet I'm working with, however I'm trying to have it further broken down.

Here is a picture of the Excel Sheet:

Excel Calculations

enter image description here

(Not allowed to add embedded pictures yet :( - 10 reputation needed, sorry!)

Pretty much, I'm trying to calculate what the average up-time is for the month, by calculating the average downtime and then subtracting it from 100.00%

What I've got works, but I'm trying to workout whether the Outage Hours column can be scrapped, and the total can be calculated with perhaps just a larger formula.

Here is a link to the spreadsheet: https://www.dropbox.com/s/msowjndootd2hh2/Spreadsheet%20Calculations.xlsx?dl=0

Thanks in advance!

Upvotes: 1

Views: 1894

Answers (1)

Denny
Denny

Reputation: 744

Just to clarify, you're looking for the result from the second column without having to include the second column, correct?

Since the second column is just the remaining difference (from 1.00) of the first column, then to get the result, all you have to do is take the remaining difference for the maximum overall to the total sum of the first column.

Meaning (assuming 12 months)...:

=12-SUM(B4:B15)

(Substitute 12 for however many months to be summed)

EDIT: OP is looking for =AVERAGE(B4:B15)

Upvotes: 2

Related Questions