Numbers123987
New Member
- Joined
- May 26, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi, I am for a few days stuck in looking for a solution to fill in the greater than or less than symbols(>, <) in a cell so that it is easily adjust the result of a sumproduct formula.
=sumproduct(--(choose(B3;C5:C25>0;C5:25<0));--(D5:D25>25%);--(E5:E25))
B3 = 2 (1 stands for greater than, 2 stands for less than)
Above formula is resulting in #Value!
Is it possible to use a cell for < and > (or 1 and 2) so that it is adding it to a sumproduct formula in combination with choose?
If yes, what am I doing wrong?
Any help as very much appreciated!
=sumproduct(--(choose(B3;C5:C25>0;C5:25<0));--(D5:D25>25%);--(E5:E25))
B3 = 2 (1 stands for greater than, 2 stands for less than)
Above formula is resulting in #Value!
Is it possible to use a cell for < and > (or 1 and 2) so that it is adding it to a sumproduct formula in combination with choose?
If yes, what am I doing wrong?
Any help as very much appreciated!