# Why does this create an error?

#### RockandGrohl

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

https://imgur.com/oXK1U74

It's just

Code:
``=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.

Last edited:

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### AlanY

##### Well-known Member
try

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

the two arrays need to be same size

Last edited:

#### RockandGrohl

##### Active Member
try

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

the two arrays need to be same size

Right you are! Thank you.

you're welcome

Replies
4
Views
554
Replies
17
Views
470
Replies
2
Views
259
Replies
7
Views
61
Replies
6
Views
307