Excel Excell Average If Formula


Joined
Aug 30, 2007
Messages
1
Reaction score
0
Good Morning All,

I have several Workbooks (named 110807, 180807 upto 100508) which include many worksheets(Lets say named Mon, Tue, Wed etc).
The format of these workbooks is identical but the numbers within are different.
I also have a separate "Totals" workbook in the same folder within which I need to calculate the average of all H15 cells across the whole range of Tue worksheets but only if Cell H3 in the same Tue worksheets is >0. The problem seems to be asking for a =AVERAGE(IF formula but no joy.
Hope that makes sense.

Any help greatly appreciated,
Thanks
Rob
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top