Excel SUMIFs with IF, OR, and AND
<p>Below is a link to the data I am working with: 
<a href="https://docs.google.com/spreadsheets/d/1iYdfVBKoX433cycJGbvtQ6hAfbD3jxkkxRTMTKuUG9o/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1iYdfVBKoX433cycJGbvtQ6hAfbD3jxkkxRTMTKuUG9o/edit?usp=sharing</a></p>

<p>I am trying to make a single function which will sum the accomplishment points of a single day with a range of different acronyms. This means I need a function that looks something like this:</p>

<pre><code>SUMIFS(Accomplishment points, range-of-acronyms,OR( Acronym="SNE",Acronym="SCE",  Acronym = " ", Acryonym = "TSD"), range-of-being, Begin-date=desired-date, range-of-end-date, enddate=desired date)
</code></pre>

<p>I know you can't us OR, but SUMIFS(SUMIFS()) doesn't work in this case either. I also have tried using ideas like SUMIFS(INDEX(METHOD) but that didnt seem to work either. </p>

<p>I appreciate your help in advance. I have looked around for people doing similar things but have been unable to find a solution that works with how many OR statements I need. </p>