Sum of a range....

[Rayzzor]

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:

=SUMIF('Raw - Canada'!$L$2:$L$5000,$E$19:$H$19,'Raw - Canada'!$Y$2:$Y$5000)

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!!!

 

[Aladin Akyurek]

=SUMPRODUCT(SUMIF('Raw - Canada'!$L$2:$L$5000,$E$19:$H$19,'Raw - Canada'!$Y$2:$Y$5000))

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:

=SUMIF('Raw - Canada'!$L$2:$L$5000,$E$19:$H$19,'Raw - Canada'!$Y$2:$Y$5000)

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!!!

 

[Rayzzor]

=SUMPRODUCT(SUMIF('Raw - Canada'!$L$2:$L$5000,$E$19:$H$19,'Raw - Canada'!$Y$2:$Y$5000))

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