<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
this is my current formula:<br />
=SUMIFS($D$3:$D$1650,$B$3:<wbr />$B$1650,$B<wbr />1657,$A$3:<wbr />$A$1650,&quot;t<wbr />est&quot;)<br />
<br />
I need to add column C to the above formula. Column C has dates information in the following format: 2012 WEEK 49, starting from 2012 WEEK 1. I need to sum the values in the following range: 2012 week 44 trhough 2012 week 50.<br />
<br />
<br />
thank you!
</div>
</div>


Hi, 

this is my current formula:
=SUMIFS($D$3:$D$1650,$B$3:$B$1650,$B1657,$A$3:$A$1650,"test")

I need to add column C to the above formula. Column C has dates information in the following format: 2012 WEEK 49, starting from 2012 WEEK 1. I need to sum the values in the following range: 2012 week 44 trhough 2012 week 50.


thank you!

Sumif formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.