Hi All ,
I need to sum these cells if a condition doesnt return an error if it returns an error to consider it zero or any other sumif formula to apply it on a larger range :
In C24 i have =C6/C5+C10/C9+C14/C13+C18/C17+C22/C21 which returned error cause some cells contained 0 values .
The formula should sound like if C6/C5 is not an error add it to C10/C9 if this later also is not an error !!!
Thank you much .
I need to sum these cells if a condition doesnt return an error if it returns an error to consider it zero or any other sumif formula to apply it on a larger range :
In C24 i have =C6/C5+C10/C9+C14/C13+C18/C17+C22/C21 which returned error cause some cells contained 0 values .
The formula should sound like if C6/C5 is not an error add it to C10/C9 if this later also is not an error !!!

Thank you much .