Formula to pull data with multiple horizontal and vertical criteria

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    I want a formula that pulls the $ amount to display in C6:D15 on the summary tab, from the data tab, based on cost type, project and period, and be able to change the periods in row 5 based on the dropdowns in C5/D5 to change and compare months

  • In "Summary" sheet C6, formula copied right to D6 and all copied down :


    =SUMIFS(INDEX(Data!$D$4:$H$13,,MATCH(C$5,Data!$C$1:$H$1,0)),Data!$A$4:$A$13,$A6,Data!$B$4:$B$13,$B6)