Getting text to come back using SumIf

[buteaur]

Hello everyone.

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!

 

[mikerickson]

SUMIFS returns a number. (Summing requres numbers)

Can you give a small example of an input and the desired result?