SUMIF value in one column greater than value in another column

[gsw811]

I'm trying to sum the values in one column if the corresponding value in another column is less than value in first column

Col1 Col2
1 0
2 1
3 3
4 3
5 6

Sum col 1 when value in col 2 is less than col1. The answer in this case would be: 7.
How can this be accomplished using SUMIF or some other formula.

 

[Vidar]

Try this array formula. Must be confirmed With Ctrl+Shift+Enter:
=SUM(IF(A2:A6>B2:B6,A2:A6))

 

[gsw811]

Perfect! Thanks.

 

[Vidar]

You're welcome