Average If. multiple criteria

Good morning all,

Long time stealer of formulas/lurker first time writer. (So big thanks you guys have helped me out 100 times)

I have a list of data in the following order A-E:

Week number, Run, Criteria 1, Criteria 2, Criteria 3
1, W456 2, 3, 1
1, W334, 1, 2, 3,
2, W334, 1, 2, 3,
2, S345, 1, 2, 3,
2, S334, 1, 2, 3,

And so on.

I want to make a table that finds the average value for each criteria for all 'Runs' that begin with W & S & N (individually) - broken down by each week.
So my table would look something like:
W N S
Week number Criteria 1 Criteria 2 Criteria 3 Criteria 1 Criteria 2 Criteria 3 Criteria 1 Criteria 2 Criteria 3
1
2
3
…..
17
18
19

*sorry for above table i'm not the most artistic person.

Thankyou Mr Spider with long legs. Glad i didn't try to work it out alone (well for longer than i already did >.>), i've never used march or index yet.