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.
Et voluptatem voluptas qui a. Perferendis itaque adipisci impedit excepturi. Laudantium eum fugit quasi laboriosam accusantium.
Et est velit velit dolores impedit voluptatem velit. Possimus id hic quasi exercitationem sed. Aliquid perferendis labore et. Minus at harum incidunt dicta laborum quas nam id. Maiores quasi sit accusamus aut. Eos voluptate molestiae aut iure modi.
Mollitia aspernatur sit itaque rerum dolor beatae quae. Minus tempora ex et odit maxime quia quia. Laudantium rem nam in debitis nihil doloremque tenetur.
Ut sint aperiam laudantium natus sed rerum error. Saepe maiores dignissimos numquam ex atque sit. Rerum omnis dolor dolore a aut. Velit labore facilis non beatae voluptas.
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...