Sum cells that contain numbers with multiple conditions

To sum values in a range that may contain errors you can use the following "=SUM(SUMIF("A2:A20","<0"),SUMIF("A2:A10",">0"))".


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top