Year

[RLJ]

I want to pull the year from the $M$5:M$2000 Range and match it up to the year in C2. However it is stating I have to many arguments in this formula.

=SUMIF(YEAR('Joel McRae'!$M$5:$M$2000,C2,'Joel McRae'!$F$5:$F$2000))

How can I adjust this formula to work?

 

[MrKowz]

Try:

=SUMPRODUCT(--(YEAR('Joel McRae'!$M$5:$M$2000)=YEAR(C2)),'Joel McRae'!$F$5:$F$2000)

 

[VoG]

Maybe

=SUMPRODUCT(--(YEAR('Joel McRae'!$M$5:$M$2000)=C2),'Joel McRae'!$F$5:$F$2000)