Sumproduct - Returns an error when one criteria is not met

[Miss XLNerd]

Hi

I've just become a member of this site so if I do something wrong please dont jump too hard on me.

I have a spreadsheet which brings data from another workbook depending on the criteria specified.

E T U V
Area Month YR Closed??
Warehouse 1 2018 NO
Warehouse 1 2018 NO
Warehouse 1 2018 NO
Sales - Office 2 2018 YES


I want to count the cells which contain "NO" where the criteria is eg. Area "Warehouse" and Month "1" If the Closed criteria is Yes, I dont want to count it, or want it to return a 0. The outcome would look like this:

Area Month Still Open
Warehouse 1 3
Sales - Office 2 0

=SUMPRODUCT(('[SAR Register 2018.xlsm]2018'!$V$2:$V$200="NO")*('[SAR Register 2018.xlsm]2018'!$T$2:$T$200=1)*('[SAR Register 2018.xlsm]2018'!$E$12:$E$200="Warehouse"))

This is my formula which brings up #N/A#

Can anyone help me out of where I am going wrong?

Thanks in advance
Deb

 

[AhoyNC]

Probably because you have different size ranges. In your formula columns V and T go from row 2 to row 200, but column E goes from row 12 to row 200. Maybe that should be
('[SAR Register 2018.xlsm]2018'!$E$2:$E$200="Warehouse")