So, I know how to write sumifs but I've never attempted to get text to come back instead of numbers.
Here's what I'm looking for:
=SUMIFS('All Data'!C:C,'All Data'!R:R,"FROG, KERMIT")
This works but it returns a number instead of the name.
Any help is appreciated as always!