Why does this create an error?

[RockandGrohl]

Thought this would be a simple calculation, boy am I wrong...

https://imgur.com/oXK1U74

It's just

=H381/(SUMIFS($D:$D,$B$377:$B$397,B381))

Seems easy enough, divide a number in H by the combined sum of numbers that match "Mercedes" criteria.

Originally I had the criteria range going from B1:B1000 but it didn't work, tried this, still doesn't work.

Thanks.

 

[AlanY]

try

$D1:$D1000,$B$1:$B$1000

the two arrays need to be same size

 

[RockandGrohl]

try

$D1:$D1000,$B$1:$B$1000

the two arrays need to be same size

Right you are! Thank you.

 

[AlanY]

you're welcome