sumifs using list of cells as critera

[joshman108]

As opposed to doing something like this:

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px 'Helvetica Neue'; color: #323333 ; -webkit-text-stroke: #323333 }span.s1 {font-kerning: none}</style>=sumifs(C:C,B:B,"<>fbk",B:B,"<>ofb")

I would like to basically do something like this:

=sumifs(C:C,B:B,<>d1:d4)

where d1:d4 holds a list of things I want to exclude.

Is this possible at all? Haven't found an answer online. Thanks
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px 'Helvetica Neue'; color: #323333 ; -webkit-text-stroke: #323333 }span.s1 {font-kerning: none}</style>

 

[joshman108]

awesome, thanks again.

 

[Jonmo1]

You're welcome.