Hi,

I have been trying to get this statement into a SUMPRODUCT statement. I have googled it, tried the various syntax that people have come up with and all i get is errors!

=SUMIFS(Data!$R$2:$R$7014,Data!$Q$2:$Q$7014,'League Table'!$D5,Data!$N$2:$N$7014,"Yes",Data!$J$2:$J$7014,"Y")

Any help turning this into a sumproduct so it can work in 2003?!!!