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
Recusandae qui praesentium maiores veritatis ut error sit est. Et qui tempore in quia.
Non quis ipsam dolores porro labore corrupti ducimus. Repellat et quod officia rerum. Itaque ex tenetur officia tempora porro voluptates fugiat. Est rem voluptatem minus suscipit accusantium commodi modi.
Quia nostrum eos sequi architecto beatae sit. Illo sunt eius qui tenetur fuga. Quod quisquam voluptatem nemo temporibus quis totam accusantium.
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...