• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

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
0
swedishmotors
Asked:
swedishmotors
1 Solution
 
barry houdiniCommented:
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
 
swedishmotorsAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now