<div>
<div class="content wysiwyg-content">
The formula 
 
=SUMIFS('205-4'!N:N,'205-4'!E:E,&quot;&gt;=B8&quot;,'205-4'!E:E,&quot;&lt;=C8&quot;) 
 
does not work unless I actually enter the contents of B8 and C8 into the formula giving 
 
=SUMIFS('205-4'!N:N,'205-4'!E:E,&quot;&gt;=411001&quot;,'205-4'!E:E,&quot;&lt;=411010&quot;) 
 
 
What is the workaround for this in Excel? 
 
Thanks 
Paul
</div>
</div>

The formula

=SUMIFS('205-4'!N:N,'205-4'!E:E,">=B8",'205-4'!E:E,"<=C8")

does not work unless I actually enter the contents of B8 and C8 into the formula giving

=SUMIFS('205-4'!N:N,'205-4'!E:E,">=411001",'205-4'!E:E,"<=411010")


What is the workaround for this in Excel?

Thanks
Paul

How to use SUMIFS with the criteria referencing a cell

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