Forum Discussion
sumif?
It works in my Excel 2013 sheet when i enter the formula with ctrl+shift+enter. Which version of Excel do you work with? You have to enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. Ctrl+shift+enter puts the curly brackets {} around the formula and calculates the arrayformula.
=IFERROR(INDEX($B$9:$K$11,MATCH($A3,$A$9:$A$11,0),MATCH(1,(B$2=$B$8:$K$8)*(B$1=$B$7:$K$7),0)),"no match")If you remove the merged cells you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
OliverScheurich Thanks for this. ON the previous example, it seems to work. But when I applied it, it didnt work for me somehow. I have re-attached an example with the formula suggested. Thanks for sharing your knowledge.
It works in my Excel 2013 sheet when i enter the formula with ctrl+shift+enter. Which version of Excel do you work with? You have to enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. Ctrl+shift+enter puts the curly brackets {} around the formula and calculates the arrayformula.
- Thanks a lot! I have 2016 version. It works now 🙂
