SUMIFS to SUMPRODUCT help

[reckless2k2]

I've got a SUMIFS formula that needs to be converted to a SUMPRODUCT in order to calc with sheets closed. I'm stuck on converting this SUMIFS below to SUMPRODUCT. I ended up creating 2 SUMPRODUCT formulas but I think it can be captured in one. Any help would be appreciated.

SUMIFS:
=(SUMIFS('another workbook'!$U:$U,'another workbook'!$Z:$Z,"DATA",'another workbook'!$M:$M,"AB001"))


The two SUMPRODUCT formulas I created:
=(SUMPRODUCT('another workbook'!$U:$U,--('another workbook'!$M:$M="AB001")))+SUMPRODUCT('another workbook'!$Z:$Z,--('another workbook'!$M:$M="AB001")))

Thanks again for any help.

 

[FDibbins]

Would this work?

=SUMproduct('another workbook'!$U:$U,--('another workbook'!$Z:$Z="DATA"),--('another workbook'!$M:$M="AB001"))

 

[reckless2k2]

Would this work?

=SUMproduct('another workbook'!$U:$U,--('another workbook'!$Z:$Z="DATA"),--('another workbook'!$M:$M="AB001"))

I'm getting a #VALUE error. That doesn't seem to be working.

 

[reckless2k2]

Apologies. This did work.

Thanks so much!!!

 

[FDibbins]

Awesome, happy to help