I'm trying to create a master Workbook that can take the average of the values of an individual cell across multiple workbooks, but given a certain condition is met. For example, I want to average all of the values of C3 (which is a number) across all worksheets, but only when cell A4 says "Sales Department" in that same worksheet.
Is there a formula that can help me with this? Thank you! This is my first post here, so please let me know if there's anything else I need.