Summing a column using multiple criteria

[tHE fLY]

I have 4 columns,

Total Client Year Category


I am wanting to add up the totals for each client IN 2014 with a certain CATEGORY

When I use SUMIFS, it only allows me to insert 2 criteria. How can I calculate totals using the 3criteria I need?

Thanks!

 

[Aladin Akyurek]

What are those 3 criteria?

 

[tHE fLY]

Year --- Column C
Client --- Column A
Category --- Column D

 

[Aladin Akyurek]

Year --- Column C
Client --- Column A
Category --- Column D

Assuming that you want to sum column B...

=SUMIFS(B:B,A:A,F2,C:C,G2,D:D,H2)

where F2 houses a client of interest, G2 a year of interest, and H2 a category of interest.

 

[tHE fLY]

I am trying to sum Column F. The other columns included Are A,C,D............... When I include 3 criteria with SUMIFS, I GET 0

 

[Aladin Akyurek]

I am trying to sum Column F. The other columns included Are A,C,D............... When I include 3 criteria with SUMIFS, I GET 0

In J2 enter:

=SUMIFS(F:F,A:A,G2,C:C,H2,D:D,I2)

where G2 houses a client of interest, H2 a year of interest, and I2 a category of interest.

 

[tHE fLY]

That worked perfectly. Thanks!

 

[Aladin Akyurek]

That worked perfectly. Thanks!

You are welcome.