Formula to return cell result when 2 criteria are met in a dynamic expanding named range, the formula will match data in Column A & B and return the result in C. Example: Match Green and Small return 6/10
A B C 1 Red Big 5/10 2 Green Small 6/10 3 Blue Medium 8/15 4 Green Big 11/50
I have tried sumproducts but hit a rock block when column A have repeated data. Thank you for your help.
Edit: layout for clarity