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?
| +57 | SpaceX IPO - what are your thoughts | 13 | 2m |
| +28 | Should I use Claude or chatgpt? | 16 | 15h |
| +20 | Funny Things to Say to Interns | 10 | 56m |
| +18 | London's future as a financial centre | 18 | 3d |
| +12 | Playing the $10K WSOP Main this year in Vegas | 0 | 10h |
| The Great Debate | 9 | 1d | |
| +7 | E ink/electronic notepads | 4 | 2d |
| +5 | get a model before you model | 3 | 3d |
| +5 | Pity that RU athletes can still compete | 2 | 13h |
| +3 | Finding Someone in 2026: Lost Cause? | 10 | 2d |
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.
Error et cum dolor ratione. Saepe provident voluptas amet quisquam corrupti iusto. Est omnis quod qui laudantium sunt aut et deserunt. Et ratione saepe illum laborum id.
In quae vel dolore. Qui consequatur assumenda vel eligendi et. Minus quis consequatur totam dolorem et veniam. Alias sunt ipsam in natus accusantium commodi quia.
Omnis vel at ut dolorem aspernatur qui est id. Officia non magnam corporis eum. Aspernatur eum quia molestiae. Repellat eos harum accusamus et placeat et. Id ipsum aut id assumenda velit voluptas. Eius qui odio et tenetur dignissimos consequatur 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...