<div>
<div class="content wysiwyg-content">
=SUMIF(Sheet1!K:K, &quot;&gt;30&quot;&amp;&quot;&lt;=60&quot;,Sheet1!N:N) 
 
Above is my formula. &nbsp;Which is not functioning. 
I need the sum of all values in N where the value in K is &gt;30 and &lt;=60 
 
K 
 
Age 
201 
77 
112 
214 
63 
36 
406 
356 
 
 
Age 
50 
 
 
Age 
111 
 
 
Age 
138 
 
 
Age 
70 
 
 
Age 
355 
78 
36 
68 
97 
22 
97 
 
 
 
N 
 
Cost 
$8440 
$4000 
$9640 
$14675 
$19985 
$20295 
$15760 
$16490 
 
 
Cost 
$12500 
 
 
Cost 
$8600 
 
 
Cost 
$12000 
 
 
Cost 
$14200 
 
 
Cost 
$25390 
$6425 
$11195 
$10500 
$12065 
$19050 
$17460
</div>
</div>

=SUMIF(Sheet1!K:K, ">30"&"<=60",Sheet1!N:N)

Above is my formula. Which is not functioning.
I need the sum of all values in N where the value in K is >30 and <=60

K

Age
201
77
112
214
63
36
406
356


Age
50


Age
111


Age
138


Age
70


Age
355
78
36
68
97
22
97



N

Cost
$8440
$4000
$9640
$14675
$19985
$20295
$15760
$16490


Cost
$12500


Cost
$8600


Cost
$12000


Cost
$14200


Cost
$25390
$6425
$11195
$10500
$12065
$19050
$17460

SumIF Nested 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.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.