Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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