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
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