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
| +43 | What Is Your Backup Plan? | 20 | 7h |
| +39 | Where are free agents signing? | 21 | 14h |
| +35 | AvalonBay Equity Residential Merger discussion | 16 | 12h |
| +34 | Future of Real Estate | 9 | 16h |
| +31 | Laughable Job Posting | 12 | 10h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 21h |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 21h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
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
Voluptas est vitae ipsum vel ducimus voluptatem eum laborum. Est perspiciatis totam doloremque voluptatem. A id amet reiciendis ducimus eum voluptates. Odit aliquam sed debitis iusto officia sequi. Nobis ut quia labore et accusantium aliquam consequuntur.
Enim eaque molestiae aliquid. Molestiae quo suscipit omnis omnis. Sint omnis hic at perferendis.
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...