Why does this create an error?

RockandGrohl

Active Member
Joined
Aug 1, 2018
Messages
455
Office Version
  1. 2010
Platform
  1. Windows
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:

Some videos you may like

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
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
try

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

the two arrays need to be same size
 
Last edited:

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,146
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
you're welcome
 

Watch MrExcel Video

Forum statistics

Threads
1,108,493
Messages
5,523,267
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top