Nov 12 2021 03:17 PM
Hello! First post here, so apologies for any faux pas.
I'm trying to get a formula that does the following:
Any tips or tricks? I can't seem to get it working.
Thanks!
P
Nov 12 2021 10:41 PM
@PatsIt Your asking for the sum of all possible combinations, so the highest possible sum would be 5 x 7 = 35 and lowest possible sum would be 5 x 5 = 25. Any combination of fives, sixes and sevens will add up to a number in this range.
If you are an MS365 subscriber, you could use SEQUENCE like this: