How to average same cell across worksheets given a condition?

%3CLINGO-SUB%20id%3D%22lingo-sub-1567748%22%20slang%3D%22en-US%22%3EHow%20to%20average%20same%20cell%20across%20worksheets%20given%20a%20condition%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567748%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20master%20Workbook%20that%20can%20take%20the%20average%20of%20the%20values%20of%20an%20individual%20cell%20across%20multiple%20workbooks%2C%20but%20given%20a%20certain%20condition%20is%20met.%20For%20example%2C%20I%20want%20to%20average%20all%20of%20the%20values%20of%20C3%20(which%20is%20a%20number)%20across%20all%20worksheets%2C%20but%20only%20when%20cell%20A4%20says%20%22Sales%20Department%22%20in%20that%20same%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20that%20can%20help%20me%20with%20this%3F%20Thank%20you!%20This%20is%20my%20first%20post%20here%2C%20so%20please%20let%20me%20know%20if%20there's%20anything%20else%20I%20need.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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