sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- 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?