Select Page

No, Excel Video 368 isn’t a fitness videos and arrays won’t help you with your abs. ABS is an Excel function that takes the absolute value of a cell. We’ll take the absolute value of a range of cells by combining ABS with an array today.
Also watch for how I write a SUMIF formula that sums all negative values. It’s not an array, but you might find it helpful. The formula is =SUMIF(F4:F18,”<0",F4:F18). The <0 part of the formula needs to be enclosed in quotes for SUMIF to work.