SumIF Nested Formula

=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
LVL 1
Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Which version of excel are you using? In Excel 2007 or later you can use SUMIFS (with an "S" on the end) i.e.

=SUMIFS(Sheet1!N:N,Sheet1!K:K, ">30",Sheet1!K:K,"<=60")

in earlier versions try subtracting one SUMIF from another like this

=SUMIF(Sheet1!K:K, ">30",Sheet1!N:N)-SUMIF(Sheet1!K:K, ">60",Sheet1!N:N)

Note the criteria needs to be reversed in the second one because you are subtracting.....

regards, barry
0

Experts Exchange Solution brought to you by