Index / match - 2 criteria - duplicate results

[dunmore83]

Hi,

I have the following Array formula;

=INDEX('Paddock-Plan-Crops'!$V$17:$V$67,MATCH(S$7,'Paddock-Plan-Crops'!$G$17:$G$67,0),MATCH(S$4,'Paddock-Plan-Crops'!$Y$17:$Y$67,0))

I need a modification for this that will sum the values in V17:V67 when duplicate combinations are found in the Match criteria.

For example S7 is searching for the words "Pivot 2" in G17:G67 & S4 is searching for the words "Silage" in Y17:Y67 - this combination exists more than once in V17:V67

Any helpers ???

 

[Special-K99]

=SUMPRODUCT(('Paddock-Plan-Crops'!G17:G67=S7)*('Paddock-Plan-Crops'!Y17:Y67=S4)*('Paddock-Plan-Crops'!V17:V67))
or
=SUMIFS('Paddock-Plan-Crops'!V17:V67,'Paddock-Plan-Crops'!G17:G67,S7,'Paddock-Plan-Crops'!Y17:Y67,S4)