SQL and Excel Sumifs conditions
<p>The best way to start off this question is with a specific Example</p>

<p><a href="https://i.stack.imgur.com/2jY1z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2jY1z.png" alt="enter image description here"></a></p>

<p>There are only three distinct claim numbers. Is there a way to sum up the billed amount for claims containing a revenue code 320 and 300 without summing up claims with revenue code '450'? In this specific example, claimNo U4343 meets the specific conditions I want which comes out to 140. I have huge data sets to work with and I just wanted to know if there is a shortcut to this process in SQL (Access syntax) and Excel 2010? </p>

<p>Thanks for your time.</p>