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.
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.