Hi monkeys,
I am trying to construct an IF formula. I have a set of data of precedent transactions, their value in one column and their industry in another. I need to find the total value of transactions per industry group, so how should I structure this formula as to reference to calculate the total value of transactions depending on industry group?
| +73 | Uchicago is paradise | 14 | 3d |
| +61 | BofA VP killed in random NYC stabbing | 36 | 2d |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 2d |
| +42 | Who Killed Wall Street | 8 | 3h |
| +14 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 3 | 7h |
| +12 | At what salary can you start calling it “fi-NANCE” | 3 | 1d |
| +11 | Lindsay Clansey | 6 | 11h |
| +9 | Wrote a rap song on finance | 1 | 14h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 3d |
| +1 | Someone just coined "the view" | 3 | 4d |
Career Resources
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.
Use =sumif instead
=sum(if(range(industries)=industry,range(values),0)) ctrl shift enter
=sumif(range of industries, industry to sum, range of values to sum)
honestly, I prefer using sumproduct rather than ever using sumif or averageif etc. Sumproduct is one of the most versatile, if not the most versatile, functions in excel so use it whenever possible.
for this situation it would be =sumproduct( (industry1:industry N = industry i)*1, value 1 : value i). Have a list of industry groups that you are summing over and drag it donw.
Sunt ut qui sed quisquam aut cum qui. Vel quis aut quidem. Aliquam et ea et et velit magni et voluptas. Et fugiat voluptatem reprehenderit beatae modi saepe.
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...