Excel Sum Rows
I have an x and a y axis, how do you sum partial range, a row, based on two column inputs. Not the entire row, but say if my y is labeled 1,2,3,4,5, and x is 10,11,12,13,14,15 then y2,x12,x13
I have an x and a y axis, how do you sum partial range, a row, based on two column inputs. Not the entire row, but say if my y is labeled 1,2,3,4,5, and x is 10,11,12,13,14,15 then y2,x12,x13
| +11 | JLL - 1st Year Analyst (Am i underpaid) | 32 | 2d |
| +3 | 2027 internships | 1 | 1d |
| +1 | MF Acquisition UW | 3 | 13h |
Career Resources
WSO Virtual Bootcamps
Career Advancement Opportunities
November 2026 Investment Banking
Overall Employee Satisfaction
November 2026 Investment Banking
Professional Growth Opportunities
November 2026 Investment Banking
Total Avg Compensation
November 2026 Investment Banking
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 | 99.2 | |
| 2 | 99.0 | |
| 3 | 99.0 | |
| 4 | 99.0 | |
| 5 | 98.9 | |
| 6 | 98.9 | |
| 7 | 98.9 | |
| 8 | 98.9 | |
| 9 | 98.9 | |
| 10 | 98.8 |
“... I believe it was the single biggest reason why I ended up with an offer...”
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hope this helps:
thanks, it does.
anyway you have a formula where i can just sum Y4 from column X11:X14
i.e. sum(I11:L11)? in the fashion you have here. My brain is fried I've been looking at this one model all day.
do a sumproduct.
using squirrel's example: sumproduct((H8:M12) * ($G$8:$G$12=4) * (($H$7:$M$715)+($H$7:$M$7>10)))
Got hit ctrl-shift-enter after typing this in
Veritatis voluptas ullam doloribus accusantium commodi qui. Quis velit et temporibus qui ut id dolore. Illo cumque est officia quibusdam reprehenderit nemo. Quidem voluptas quam quos odit omnis fugiat ab. Molestiae sed sit provident impedit. Dicta at quos voluptatem ipsam. Iste a dolorem expedita aperiam.
Porro consectetur asperiores eos quasi eligendi nemo officiis. Sequi nisi molestias numquam adipisci. Omnis voluptatem hic harum fugit corrupti voluptate.
Ut rem hic eligendi. Dicta praesentium ut debitis aut molestiae sunt. Nemo enim in non enim cum reiciendis nesciunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...