how to get the sum of a range in which two specific if conditions apply

nadavrock

New Member
Joined
May 15, 2019
Messages
24
i have so far =SUMIFS(a2:b18, a2:b18, a2<b2)<b2)<b2)
i want to get the sum in column a. in which b is greater than a. and a is greater than 30. example:
a b
10 11
11 10
12 10
60 12
100 150
60 120


in this exmaple the sum should returns 110</b2)<b2)
 
Last edited:

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

nadavrock

New Member
Joined
May 15, 2019
Messages
24
wont let me edit. wannted to fix. what i have so far is =SUMIFS(a2:b18, a2:b18, a2<b2)
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,952
Office Version
2010
Platform
Windows
i have so far =SUMIFS(a2:b18, a2:b18, a2<b2)<b2)<b2)
i want to get the sum in column a. in which b is greater than a. and a is greater than 30. example:
a b
10 11
11 10
12 10
60 12
100 150
60 120


in this exmaple the sum should returns 110</b2)<b2)
Why is the answer 110... shouldn't it be 100? The 10 you from the first line violates your "and a is greater than 30" rule, so why are you counting it?
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,952
Office Version
2010
Platform
Windows
wont let me edit. wannted to fix. what i have so far is =SUMIFS(a2:b18, a2:b18, a2< b2)
Put a space after your < sign, otherwise this forum's interpreter thinks you started and HTML tag.
 

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
I think the result should be 160 - two last rows meet the criteria.

M.
 

nadavrock

New Member
Joined
May 15, 2019
Messages
24
yes marcelo that works. thank you. the idea of the example was indeed for the 2 last rows to meet cirteria. i miscalculated what sum that would give
 

Watch MrExcel Video

Forum statistics

Threads
1,099,891
Messages
5,471,325
Members
406,757
Latest member
dizzane

This Week's Hot Topics

Top