
Had to be Eldrazi because then i could search it up/ cast if for less with my Eye of Ugin

undecided44 wrote:
sorry to be explaining the joke here, but are you sure you'll get what you want from your formula? The different argument order between the old =sumif(...) and the new =sumifs(...) is making me wonder about your intent...
sumif([criteria] range, criteria, [sum range]) would give you power equal to the sum of the power of all creatures not named $VI$65536,
while sumifs(sum range, criteria range 1, criteria 1, [criteria range 2], [criteria 2],...) would give you 0 because the text cells in the range Creature:Name count for 0 in the sum
the way you have it is funnier, but much less of a challenge
Vantar wrote:-snip-
Final something that combines my love of M:TG, LRR and Excel
I am a Microsoft Office Specialist exam proctor.
-snip-
undecided44 wrote:Way way way off topic, but Vantar I have an design requirement you could probably help me address, or at least point me toward a decent resource, can I PM with a professional question?
Users browsing this forum: No registered users and 1 guest