Forum Discussion
sumif?
Hello. I have a situation.
I would like to return the value, lets say in Q4 Scenario 1 and 2 in the correct cell. I am not having any luck as it is returning some numbers that do not even make sense.
The values should be in the grey cells in the attached file.
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.
4 Replies
=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.
