SUMIFS

[RodneyC]

I need help with finishing my SUMIFS formula. Here's what I have so far:

=SUMIFS(Data!A5:A318,Ranker!C11,

Next what I need it to do is look in the Data tab, specifically cell D4 and see if it matches cell E6 in my Ranker Tab. It should sum everything in Data D5:D318: Here's what I'm trying

=SUMIFS(Data!A5:A318,Ranker!C11,Data!D4,Ranker!E11,Data!D5:D318)

and I get a #SPILL! error. What am I missing? If SUMIFS isn't the right path, what is?

Thanks in advance

 

[Fluff]

Maybe

=IF(Data!D4=E11,SUMIFS(Data!D5:D318,Data!A5:A318,C11),"")

 

[RodneyC]

Maybe

=IF(Data!D4=E11,SUMIFS(Data!D5:D318,Data!A5:A318,C11),"")

yahtzee! Once again you've given me the solution. Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.