Average group of items on one sheet from list of data value on another sheet

[janljan]

Hello,

Is it possible to get a total average for a list of items on one sheet when the data is on another sheet. Example: what is the average for this group of items for Pending Actions. Excel file attached.

BUSINESS ADMINSTRATION
ACCOUNTS RECEIVABLE
ACCOUNTS PAYABLE
BUSINESS ADMIN MANAGEMENT
BUSINESS DEVELOPMENT
BUSINESS SYSTEMS
CONTROLLING
FINANCE
HR MANAGEMENT
IT COORDINATION
QUALITY AND ENVIRONMENTAL MGMT.

[mrshl9898]

The attached is already doing this I would think... Is there something incorrect in there?

[MarvinP]

Hi janljan,

See if 3 pivot tables below your data does what you want. See the attached. Time to learn Pivot Tables?

PT for DIAR Report Data.xlsx

[janljan]

Yes it does. I think I was making more out of this than necessary.

Thank you for responding.

Regards,
Jan

[janljan]

Hi,

Yes it does. Thanks you for responding.

Regards,
Jan