I am trying to nest an ABS function inside a SUMIF equation. Not sure if it is possible. Basically trying to sum the absolute values of a list of data if certain criteria are met. The formula I am trying to get is something like this...

SUMIF($A$1:$M$1,"=P",ABS($A$8:$M$8))

Any thoughts on how I can achieve this greatly appreciated

**Important Notice**

We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!