wont let me edit. wannted to fix. what i have so far is =SUMIFS(a2:b18, a2:b18, a2
i have so far =SUMIFS(a2:b18, a2:b18, a2i 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
Last edited by nadavrock; Jun 13th, 2019 at 05:51 PM.
wont let me edit. wannted to fix. what i have so far is =SUMIFS(a2:b18, a2:b18, a2
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
I think the result should be 160 - two last rows meet the criteria.
M.
Maybe
=SUMPRODUCT(--(B2:B7>A2:A7),--(A2:A7>30),A2:A7)
M.
Rick's "mini" blog... http://www.excelfox.com/forum/f22/
.
Want to post a small screen shot? See Part B here.
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
You are welcome. Thanks for the feedback.
M.
Like this thread? Share it with others