sumifs, matching dates.

[srizki]

On sheet1, I have dates in column A, once only, I need to match that date with the dates multiple times on column B of sheet two and sum the amount from column B.
I am using the SUMIFS function on the 2016 version of Excel but getting #VALUE! error.
Please advise

=SUMIFS('R.2 MM-AR-Detail'!B:B,'Open Injected AR Balance 7.08'!A5,'R.2 MM-AR-Detail'!I:I)

Best regards,

 

[Fluff]

You have the arguments in the wrong order. The sum range should be 1st not last.

 

[srizki]

You have the arguments in the wrong order. The sum range should be 1st not last.

Thank you, I thought it would be the same order as the COUNTIF.
Yes, it is working,
Thanks again.

 

[Fluff]

Nope, sumifs & sumif have a different order.

 

[Joe4]

Thank you, I thought it would be the same order as the COUNTIF.
Yes, it is working,

A good thing to do/verify is to just do a Google search on the function.
There are tons of good articles, explanations, and examples on all of them that show you exactly how to use these functions.

 

[srizki]

A good thing to do/verify is to just do a Google search on the function.
There are tons of good articles, explanations, and examples on all of them that show you exactly how to use these functions.

Thank you, Joe.
Best regards,