# Thread: how to get the sum of a range in which two specific if conditions apply Thanks: 0 Likes: 0

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

i have so far =SUMIFS(a2:b18, a2:b18, a2 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

2. ## Re: how to get the sum of a range in which two specific if conditions apply

wont let me edit. wannted to fix. what i have so far is =SUMIFS(a2:b18, a2:b18, a2

3. ## Re: how to get the sum of a range in which two specific if conditions apply

i have so far =SUMIFS(a2:b18, a2:b18, a2 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
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?

4. ## Re: how to get the sum of a range in which two specific if conditions apply

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.

5. ## Re: how to get the sum of a range in which two specific if conditions apply

I think the result should be 160 - two last rows meet the criteria.

M.

6. ## Re: how to get the sum of a range in which two specific if conditions apply

Maybe

=SUMPRODUCT(--(B2:B7>A2:A7),--(A2:A7>30),A2:A7)

M.

7. ## Re: how to get the sum of a range in which two specific if conditions apply

Originally Posted by Marcelo Branco
I think the result should be 160 - two last rows meet the criteria.
M.
I missed that last one!!!

Originally Posted by Marcelo Branco
Maybe

=SUMPRODUCT(--(B2:B7>A2:A7),--(A2:A7>30),A2:A7)
Yeah, that is probably what the OP is after.

8. ## Re: how to get the sum of a range in which two specific if conditions apply

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

9. ## Re: how to get the sum of a range in which two specific if conditions apply

You are welcome. Thanks for the feedback.

M.