SUMPRODUCT with INDEX and 2x MATCH

[horizonflame]

Hi

=IFERROR(INDEX(CWDTWork!$F$4:$F$5000,MATCH(1,INDEX(($D$1=CWDTWork!$G$4:$G$5000)*($A3=CWDTWork!$A$4:$A$5000),0,1),0)),0)

I need to sum all the results from the column and understand SUMPRODUCT may be the answer.

Any help would be appreciated

 

[horizonflame]

Edit: SOLVED, was the number reference in another sheet not as number format.

 

[Eric W]

Glad you figured it out.