Sumproduct returning div/0 with no division in formula

[The Doctor]

I'm trying to summarize key P&L accounts by Trial Balance week, and I've decided sumproduct is the best formula for that. I'm currently using, (in the example sheet attached):
=SUMPRODUCT((Sheet1!$C$2:$C$369=$A2)*(Sheet1!$F$1:$BN$1=B$1)*Sheet1!$F$2:$BN$369)

This returns the result #DIV/0! which I find odd since I'm not dividing anything.

What is the breakdown in the way I'm using this formula, because I can't locate any errors in my data that would pull this result to my summary page. I've tried making it an array to no avail.

Thanks to all the ninjas who will have me up and running after a cup of coffee,

The Doctor

 

[Chihiro]

That's because you have #Div/0! error in sheet1 within referenced range.

Either remove those errors, or change your formula to something like below.
=SUMPRODUCT((Sheet1!$C$2:$C$369=$A2)*(Sheet1!$F$1:$BN$1=B$1)*IF(ISERROR(Sheet1!$F$2:$BN$369),0,Sheet1!$F$2:$BN$369))

Confirmed as array (CSE)

 

[Khalid NGO]

Hi,

Little shorter with IFERROR:

=SUMPRODUCT((Sheet1!$C$2:$C$369=$A2)*(Sheet1!$F$1:$BN$1=B$1),IFERROR(Sheet1!$F$2:$BN$369,))


CSE

Regards,

 

[bosco_yip]

Another option and in non-CSE:

=SUMPRODUCT((Sheet1!$C$2:$C$369=$A2)*INDEX(Sheet1!$F$2:$BN$369,,MATCH(B$1,Sheet1!$F$1:$BN$1,0)))

Regards