Linking Distributors and Profit to a Summary

[Jay_one25]

I have many different distributors and sources where I get product for my business. I'd like a section on my excel page to summarize how much profit each source is providing. My current sheet already tracks sources and profit for each individual item, but I'd like it to add up everything and automatically show a summary for each of my sources. Any insight on how to do this would be very appreciated.

 

[RedBeard]

Sounds like a job for a pivot table: https://support.office.com/en-us/ar...eet-data-A9A84538-BFE9-40A9-A8E9-F99134456576

 

[ttray33y]

I have many different distributors and sources where I get product for my business. I'd like a section on my excel page to summarize how much profit each source is providing. My current sheet already tracks sources and profit for each individual item, but I'd like it to add up everything and automatically show a summary for each of my sources. Any insight on how to do this would be very appreciated.

Pivot Table?
OR use SUMIF function,
Say Column A has your Distributors list & Column B got the values/prices or whatever.
try:

=sumif($A$1:$A$9999,"DISTRIBUTOR NAME",$B$1,$B$9999)

 

[Jay_one25]

Thanks for the quick responses! The SUMIF function seems to do the trick, but when I try to get the values from other sheets I get a #VALUE! error. I'm not sure what I'm doing wrong. Sorry, I'm not very advanced in Excel.

=SUMIF(Sheet1:Sheet12!$M$7:$M$999,"DistributorA",Sheet1:Sheet12!$L$7:$L$999)