abs function

Hi all, I want to count the cells in column 'F' where the value is >='I2' AND the Absolute value of 'E:E' > 'I7', but some of the cells in 'E:E' contain text. Excel doesn't like this: =COUNTIFS(F:F,">="&I2,ABS(E:E),">="&I7). Any help is deeply appreciated. Thanks much in advance.

Hey All, I'm trying to get a 90 day total from a set of data, using the absolute values of the data, as some of the data comes back as negative numbers; column A is the date the data was entered, column C is the data values. I have a formula to get the 90 day total (shown below*) but I'm...

Am I able to use the ABS function on this formula somehow? =SUM(COUNTIFS('Sheet1'!A$2:A$191,{"0*","1*","2*","3*","4*","5*","6*","7*","8*","9*"},'Sheet1'!E$2:E$191,">"&F8)) I tried the following but it is not working...

How could i get the following excel formula to work using VBA: {=LARGE(ABS($D$18:$D$23),G23)} In this example i have my data in cells D18:D23 and in cells G18:G23 numbers 1 to 5, so with the formula above in H18 i can drag it down to H23 to get the 1st - 5th largest absolute values. Using VBA...

I have a field that is simply calculating the difference between two other fields. Although the results are negative numbers, positive numbers or 0, the person who requested the report wants to see the absolute value. So I used ABS(c2-e2). They also wanted icon sets (the arrows), so they can...

I have a pivot table in Excel 2013/Office 7 that is calculating a change in our operating income from year-to-year and showing the difference as a percentage. In my Value Field Settings it is: *Show Value as a % Difference, Base Field is Fiscal Year and Base Item is Previous Year. In the...

Hi All, I am really struggling with the following formula: MATCH(MIN(ABS(Ann_TaylorRegularBust-B4)),ABS(Ann_TaylorRegularBust-B4),0) I am trying to find the cell in the named row "Ann_TaylorRegularBust" that is closest to the input bust size in cell B4. This formula works when I use actual...