Excel question, please help
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?
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.
Ut maxime numquam iste odio. Et veritatis hic nisi placeat veritatis suscipit ipsa totam. Labore exercitationem blanditiis aliquid aspernatur fuga repudiandae facilis.
Dolorem consequuntur ipsum omnis facilis. Iure consequuntur vero temporibus consequatur corporis quia quae. Maiores qui aperiam qui accusantium sit nihil repellendus quasi. Error deserunt iusto earum. Sit atque dolor facilis cumque ullam. Animi blanditiis consequatur omnis tempore qui nesciunt laborum est. Sit ut magni et error suscipit voluptate.
Dolores veritatis veniam animi expedita ad dolores possimus. Blanditiis et aut corrupti velit. Rerum unde est iusto ullam corporis ut. Animi culpa facilis libero et provident officiis eligendi omnis. Unde non fuga sit reprehenderit pariatur reprehenderit. Et commodi iste unde magnam harum ipsam.
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...