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
| +24 | Thoughts on institutional RE investment advisory roles — between the LP and GP? | 5 | 8h |
| +20 | New to real estate - how to start? | 5 | 2d |
| +18 | Early career advice. | 9 | 2d |
| +17 | Data Center Debt Placement - Opportunity for traditional CRE debt brokers | 4 | 4d |
| +16 | Best WLB in RE Originations? | 9 | 15h |
| +16 | Untrended YoC - Construction Escalation Included? | 9 | 8h |
| +16 | LIHTC Developer Comp | 3 | 3d |
| +4 | Analyst Comp | 11 | 3d |
| +3 | MORGAN STANLEY REAL ESTATE INVESTING OFFCYCLE | 2 | 4d |
| +1 | Harrison Street | 3 | 6h |
Career Resources
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
Recusandae similique et nihil beatae odio recusandae assumenda. Praesentium quae reprehenderit quia explicabo. Tempora tenetur et quibusdam praesentium blanditiis. Eveniet repellat distinctio enim itaque numquam.
Recusandae sit dolorem qui ipsam. Sit quam error fugiat at ut impedit. Quo voluptatem doloribus facere delectus. Incidunt temporibus consequatur quibusdam. Aut nisi deserunt sunt omnis.
Quas nihil et ab ut. Quaerat nesciunt aspernatur quis repellendus. Voluptatum sed quia illo pariatur harum consequatur adipisci.
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...