sharky12345
Wellknown Member
 Joined
 Aug 5, 2010
 Messages
 3,340
 Office Version

 2016
 Platform

 Windows
Guys,
I've searched everywhere for the solution to this problem so hope someone can help;
I want the formula that will give me the average of Column E only provided Column B has the figure 2 in it.
Column E is numeric values only and I want the average of the values if 2 appears in column B  BUT the columns are on a seperate sheet, (called '1'), and this is what appears to be causing the issues.
Can anyone suggest a solution?
I've searched everywhere for the solution to this problem so hope someone can help;
I want the formula that will give me the average of Column E only provided Column B has the figure 2 in it.
Column E is numeric values only and I want the average of the values if 2 appears in column B  BUT the columns are on a seperate sheet, (called '1'), and this is what appears to be causing the issues.
Can anyone suggest a solution?