Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
June 30, 2026
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
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
Ut non deserunt fugit vitae et. Reprehenderit provident minima aspernatur facilis dolorem voluptatem.
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...