Sum values with multiple conditions

[wanderlustsouls18]

Hello, I am trying to get a sum using multiple conditions.
This calculation " =IF(L6="PSH",SUM(M6-U6),IF(O6<T6,SUM(O6-U6),SUM(T6-U6))) " works just fine.

However, I have a need added a new column I also need in the conditions.
I entered " =IF(L6="PSH",SUM(M6-U6),IF(O6<T6,SUM(O6-U6),SUM(T6-U6)),if(and(o6<q6,sum(o6-u6),sum(q6-u6)))) "
which only shows the formula in the cell, not the sum of the calculation.

Any assistance to correcting this formula would be very much appreciated.

 

[dreid1011]

If you copied the formula directly from your sheet, it looks like there may be a space before the = at the start.

 

[wanderlustsouls18]

If you copied the formula directly from your sheet, it looks like there may be a space before the = at the start.

Thank you, when I remove the space in front of the "=" it tells me there is an error with the formula.

 

[Scott Huish]

You have already used all the TRUE/FALSE POSITIONS for the original IFs. You also have an AND that make no sense, that althought it's a parenthesis, there is no point to an AND with only 1 condition. You also don't need to use SUM, you can just subtract.