# 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  Reply With Quote

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  Reply With Quote

3. ## Re: how to get the sum of a range in which two specific if conditions apply Originally Posted by nadavrock 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?  Reply With Quote

4. ## Re: how to get the sum of a range in which two specific if conditions apply Originally Posted by nadavrock 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.  Reply With Quote

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.  Reply With Quote

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.  Reply With Quote

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.  Reply With Quote

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  Reply With Quote

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.  Reply With Quote

## User Tag List

=sumifsa2b18, a2b18, apply, conditions, specific 