# Sum of a range....

#### Rayzzor

##### Board Regular
Hey all,

I was wondering if there is a way to get a sum of a column of values based on a series range of cells.

This is the scenerio:

c19 has the text = 4X
d19 has the text = 83
e19 = 5M
f19 = C2
g19 = KN
h19= 21

Now what I am trying to do (without making the formula 15 miles long) is create a total of the range 'Raw - Canada'!\$y\$2:\$y\$5000 if 'Raw - Canada'!\$L\$2:\$\$5000 has one of the values I listed above.

Is there a way to have the formula similar to this:

Or do I have to do a sumproduct and declare every single one? (which will be a problem because I have another formula with 9 cases.

Thanks!!!

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Rayzzor said:
Hey all,

I was wondering if there is a way to get a sum of a column of values based on a series range of cells.

This is the scenerio:

c19 has the text = 4X
d19 has the text = 83
e19 = 5M
f19 = C2
g19 = KN
h19= 21

Now what I am trying to do (without making the formula 15 miles long) is create a total of the range 'Raw - Canada'!\$y\$2:\$y\$5000 if 'Raw - Canada'!\$L\$2:\$\$5000 has one of the values I listed above.

Is there a way to have the formula similar to this:

Or do I have to do a sumproduct and declare every single one? (which will be a problem because I have another formula with 9 cases.

Thanks!!!

Worked perfectly.... thank you so much!!!!

Replies
6
Views
204
Replies
5
Views
167
Replies
1
Views
95
Replies
10
Views
336
Replies
0
Views
460

1,203,455
Messages
6,055,541
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back