Example.xls
Hi all,
So I have a spreadsheet which lists alternating columns of "Scheduled" and "actual" hours of items which our company needs to maintain for each month. The names of the items are listed in the rows. Depending on the maintenance, (tier 1, tier 2, tier 3) the scheduled hours for each month will be different. The scheduled hours will be set (ex. Tier 1 maintenance will always take 2hrs, tier 2 always 6 hrs etc.). So I will need to average the actual hours based on the tier categories (tier 1,2 and 3).
So is there a way to average the actual hours of each month based on the the values of the corresponding scheduled hours?
Heres an example: (refer to the attached spreadsheet)
in this spreadsheet, there are 2 tiers: 1M ELECTRL PM GERT COMP W/IFIX and 2M CREATE DRIVE IMAGE AND PLC CODE BACK. They have scheduled hours of 2 and 4hrs respectively.
So is there a way for me to average all the tier 1 and tier 2 actual hours for each maintenance item seperately? (e.g. average all of the actual hours of maintenance item 48360 that contains scheduled hours of 2).
Another way to say this is to Average across the orange cells for each maintenance item only if the yellow cells are of a certain value.
Sorry for the confusing explanation, any help is appreciated!!
Bookmarks