Multiple criteria question

  • Thread starter Thread starter Lise
  • Start date Start date
L

Lise

Hi everyone

I have 7 columns in a worksheet - columns A-F are formulated to copy
specific cells from other worksheets within the same workbook. Column A is a
name column B is a % etc.

I want to enter a formula that calculates the average of columns B, D and F
if the corresponding cell in columns A, C and E are the same name ie if John
smith is say in a2, c13 e20 calculate the average of the cells in b2, d13 and
F20.

Hope this makes sense


Thanks

Lise
 
Hi Lise,

Assuming the name in a column not repeating, I have a quite long formula
here, pls see if this fit your need.
=AVERAGE(VLOOKUP("John Smith",$A:$B,2,FALSE),VLOOKUP("John
Smith",$C:$D,2,FALSE),VLOOKUP("John Smith",$E:$F,2,FALSE))
 
Back
Top