Marbles | a | b | c | d | e | f | g | h | i | Result reqd |

red | wip | wip | returned | wip | changed | wip | returned | wip | acquired | 0 Days |

green | returned | returned | returned | wip | returned | returned | wip | wip | returned | 0 Days |

black | wip | wip | returned | wip | returned | wip | changed | wip | wip | 2 Days |

yellow | wip | wip | returned | wip | wip | returned | wip | wip | returned | 0 Days |

white | wip | wip | wip | changed | wip | returned | wip | returned | wip | 1 Day |

blue | returned | wip | wip | returned | wip | 1 Day | ||||

amber | wip | returned | wip | returned | wip | wip | 2 Days | |||

navy | returned | wip | returned | wip | wip | wip | wip | 4 Days |

Please help how to get the result; have tried with below formula but not getting the expected results with multiple criteria.

=IF(COUNTA(B2:J2), LOOKUP(2, 1/(B2:J2<>"returned"), COLUMN(B2:J2)- COLUMN(B2)+1)- IFERROR(LOOKUP(2, 1/(B2:INDEX( B2:J2, LOOKUP(2, 1/( B2:J2<>"returned"), COLUMN(B2:J2)- COLUMN(B2) +1))="returned"), COLUMN(B2:J2)- COLUMN(B2)+1), 0),0)