Forum Discussion
RANGE with SUM and XLOOKUP
Hello, I need support from a person who has installed WIN and Excel in us-US language. Unfortunately I do not have one available at the moment. The above data range (in green) is calculated us...
=SUMPRODUCT(($B$2:$B$14>=$H$2)*($B$2:$B$14<=$I$2)*($E$2:$F$14))An alternative could be SUMPRODUCT.
thank you for the alternative solutions, fine and good, but my goal is different.
the following function / formulas (excerpt from a larger thing) in the us system works very well.
Formular / Function: =CHOOSE({1;2;3},{"a","b","c"},{"d","e","f"},{"g","h","i"})
Who has the imagination to show me this formula / function modified and no other in the European system? If your imagination fails you, no problem, I have the solution.
I think it's clear what I'm trying to get across after that.
- Not very clear about your question.
If possible, share your file and show expected result. - Maybe you can share that goal with us. It's not clear why XLOOKUP/SUM has to be used for this task. Those functions can be used to obtain the sum but it's not sustainable (nor elegant) if you have more than 2 dates. FILTER or SUMPRODUCT makes more sense.
=WAHL({1;2;3};{"a"."b"."c"};{"d"."e"."f"};{"g"."h"."i"})
This is the formula in german Excel. However i don't understand the connection to your initial question with SUM and XLOOKUP.
