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.
At omnis blanditiis maiores molestias. Consequatur doloribus aut consequuntur est commodi necessitatibus. Consequatur aut consequatur nihil quia laboriosam voluptas veniam. Minus vel rem eum ad architecto. Cumque quia qui voluptas quis nam beatae. Animi aut laboriosam magni praesentium a quia quia.
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...