SUMIF with multiple criteria

[FirstWorldAnalyst]

Hi Everyone!

Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet.

I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand.

Ex:

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]BarnMart[/TD]
[TD]John[/TD]
[TD]$4.88[/TD]
[/TR]
[TR]
[TD]Stark Ind[/TD]
[TD]Jill[/TD]
[TD]$3.87[/TD]
[/TR]
[TR]
[TD]SteinMart[/TD]
[TD]John[/TD]
[TD]$7.82[/TD]
[/TR]
</tbody>[/TABLE]

I need to build a separate summary sheet for each brand and those employees totals earned under that specific brand.

Normally, I'd create a summary sheet with an employee name column & a payout column that uses a formula like:

=SUMIF(Names,A2,Commission), but that would just total all the commission amounts in my data sheet and not allow me to separate out the brands.

Any help/assistance would be greatly appreciated!

 

[jtakw]

Hi,

For Excel 2007 and newer, look into SUMIFS

 

[Aladin Akyurek]

Like this...

=SUMIFS(Commission,Names,A2,Brands,B2)​