How to average same cell across worksheets given a condition?

Highlighted
Occasional Visitor

Hello - 

 

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. 

0 Replies