Getting values from different table structure

[Excel-Forward]

Hi All,

I want to know if this is possible. I'm trying to create a formula for two rows (Forecast & Actuals) The Actual data input sheet is laid out in a way I can easily do the SUMIFS formula to get the required information in each cell. The trouble I'm having is the forecast input sheet has the weeks going across like this.

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

I don't know how to structure the formula to show sum of forecasts for each row in my Master sheet using the adjacent rows for criteria? is there something I can do for the forecast input sheet to have the weeks laid out in rows i.e. creating a new table of sort.

Any Help would be great.