Excel Query

[Alex H]

I'm normally ok with Excel, but been working through a spreadsheet tonight and can't do what I want to - the data below is a small sample.

I want to post the average attendance to a Cell, when the Home team is specified and the result is specified, so AVERAGE IF A2:A11 = "Bolton" AND C2:C11 = "W", for example. Any geniuses out there?

 

[iain187]

I've not got excel handy but a pivot table will probably do it

 

[Willo]

Create another column so E2=A2&C2, E3=A3&C3 etc
Then use SumIF

e.g. SUMIF(E:E,BoltonW,D)

​

 

[Alex H]

Create another column so E2=A2&C2, E3=A3&C3 etc
Then use SumIF

e.g. SUMIF(E:E,BoltonW,D)

​

​Winner Winner Chicken Dinner!

 

[Willo]

Nay problem