SUMPRODUCT on multiple rows returns #Value! error

[ebs530]

Hi there,

I am trying to just simply sum multiple rows based on one criteria, so figured the sumproduct formula should be able to work. I keep getting the #VALUE! error and I have verified that my array is pulling the same amount of cells and what not.

I have attached a sample workbook of what I am trying to accomplish. I feel like I have narrowed down the problem to being that in columns B62:E62 (financial tab in attached workbook) of the data I am trying to pull in, there are spaces in the cells. This is how the data from our system prints these reports so there is no work around reformatting this. I'm not sure why this would cause an issue but it seems too.

Any help is greatly appreciated.

Thanks,

[Jean.P28]

With a sum formula

[ebs530]

Can you help me understand that formula? How does it know to grab all the columns?

[Jean.P28]

MySum is a named range(B4:E4), than match de row jou need en go x rows down and make the sum

[FlameRetired]

You are correct about the blanks in B:E.

Try

Please Login or Register  to view this content.