Hi! I have a database and I want to obtain the absolute values based on some conditions.
The original contains the the first 3, so given the massive amount of data of the real database, for my calculus I would rather include the operation of the absolute value in the formula instead of adding a new column. (Is there any possible way of doing it? Maybe with dynamic arrays?)
The formula in E5 =SUM(SUMIFS($E:$E;$A:$A;L$4&"*";$C:$C;"<>ZZZ";$B:$B;$H$5:$I$5))
Thank you!
TYPE (A) | CODE (B) | BOOK (C) | VALUE (D) | ABS VALUE (E) |
A-XXX | 1998 | YYY | 5 | 5 |
P-XXX | 1998 | YYY | -3 | 3 |
O-XXX | 3003 | ZZZ | 6 | 6 |
A-XXX | 1998 | ZZZ | -9 | 9 |
P-XXX | 4605 | YYY | 4 | 4 |
O-XXX | 2008 | YYY | -13 | 13 |
The original contains the the first 3, so given the massive amount of data of the real database, for my calculus I would rather include the operation of the absolute value in the formula instead of adding a new column. (Is there any possible way of doing it? Maybe with dynamic arrays?)
The formula in E5 =SUM(SUMIFS($E:$E;$A:$A;L$4&"*";$C:$C;"<>ZZZ";$B:$B;$H$5:$I$5))
Thank you!