Anything obviously wrong with this SUMIFS ?

[slam]

Hi everyone!

I'm trying to SUM the values in L2:L639 where there are two matches: A26 on the Unique Projects worksheet matches values from F2:F639 on the Not Uploaded worksheet AND where B26 on the Unique Projects worksheet matches values from K2:K639 on the Not Uploaded worksheet.

=SUMIFS('Not Uploaded'!$L$2:L$639,'Unique Projects'!$A26,'Not Uploaded'!$F$2:$F$639,'Unique Projects'!B26,'Not Uploaded'!$K$2:$K$639)

Getting #VALUE! pus the formula is automatically filling down 639 rows, which I don't understand. There are definitely matches that should be summed. Where did I go wrong?

Thanks

 

[Fluff]

Make sure that you don't have any #value errors on the Not Uploaded sheet.

 

[Marcelo Branco]

The Sintax should be
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

NOT
=SUMIFS(sum_range, criteria1,criteria_range1,criteria2, criteria_range2)

M.

 

[slam]

Thank you Marcelo, I must admit I never realized that made a difference, and I must have been lucky with correct order in the past!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.