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