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.
Dolor dolore et odit esse reprehenderit eos. Cumque veritatis nesciunt et aliquid harum.
Porro praesentium et voluptas quo. Dolores molestias repudiandae ut voluptate et ut. Ullam dignissimos doloribus modi.
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...