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)

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: