Re: Countif & min

Hello,

I have attached a new sheet

The benefits examples have all been provided from 1-9 although the actual benefits are for illustration purposes only, in actual fact if the limits remaining (G2, G3, G5) are depleted would be zero, that's the part I can't figure out as would create circular references

The VLOOKUP formula can be updated to include the new criteria

The only thing left is how to amend the benefits range in two ways

Benefits paid either (minimum) C8:C16 (individual row), or balance of limit available either G2, G3 or G5 (this formula needs amending to show balance remaining from associated cells F2, F3 & F5 based on benefits paid C8:C16

I have now incorporated D8:D16 if a value exists into C8:C16 (which may/may not be best formula)

This calculation is close to creating circular references so is tricky, again not sure how to incorporate into range F8:F16

Thank you