<div>
This is Office 2010. Your first formula worked perfectly. Thanks.
</div>


This is Office 2010. Your first formula worked perfectly. Thanks.

<div>
Thanks. The first formula was exactly what I needed.
</div>


Thanks. The first formula was exactly what I needed.

<div>
<div class="content wysiwyg-content">
I am having difficulties with coming up with a correct formula. I need a formula that says to sum F12:F106 with the following two criterias.<br />
<br />
1. &nbsp;criteria range of C12:C106 and criteria 36<br />
<br />
2. criteria range of D12:D106 criteria of date is greater than 12/31/2012 and less than 1/1/2014<br />
<br />
I am doing fine all the way up through the first criteria. The date formula is what is giving me fits.
</div>
</div>


I am having difficulties with coming up with a correct formula. I need a formula that says to sum F12:F106 with the following two criterias.

1.  criteria range of C12:C106 and criteria 36

2. criteria range of D12:D106 criteria of date is greater than 12/31/2012 and less than 1/1/2014

I am doing fine all the way up through the first criteria. The date formula is what is giving me fits.

I need Excel formula that is sum based on multiple criteria ranges

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