Sum number range with two sets of criteria listed with merged cells

Hey, everyone!

I've been searching for a formula to solve this one, to no avail it seems...

On the Data tab, but displayed on the Simplified tab, I'd like to sum the numbers listed in column C if the it matches the adjoining cells in both A and B columns.

I tried using this formula, but it didn't work...

=SUMIFS(Data!C:C,Data!A:A,"Jason",B:B,"Calls")

I feel like I have the ability to be very specific with the information, just haven't figured out how to point it in the right direction.

Any ideas?

Thanks in advance, guys!

Hey, Sambo...thank you for the reply! Yes, I typed it incorrectly in this post but I did try this one on my original copy...thank you. For whatever reason, however, it just comes up with "32" as the result. I fear it just looking at that one cell, C2, as a result. This is what I experienced before...any ideas?

Flame, how awesome! I see what you did there...instead of having it looking to "assume" the data in the merged cells, you had it spelled out. And this could work as a fix-all, copy-and-paste for future documents. I will give it a shot. Thank you so much for the assistance!