SUMIFS Question

[rthompson55125]

Hello, I have a great SUMIFS formula that pulls from a drop down menu. I have multiple criteria and conditions well established, however if the criteria selection is "ALL" from the drop down list, I'd like to sum all those totals based on the other criteria selected.

A. Joe's Totals
B. Barb's Totals
C. Jimmy's Totals
D. All (All their totals)

Any idea what I'd add onto the end of it to sum "All" when selected?

Thank you

 

[texasalynn]

why not just make that be a sum not sumif

 

[Aladin Akyurek]

Care to post the formula for Joe for example?

 

[rthompson55125]

Care to post the formula for Joe for example?

Here is the formula. Sorry, the criteria/data is on another tab.

=SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,'Manager''s Dashboard'!$L$2,Transactions!$D:$D,'Manager''s Dashboard'!$L$4,Transactions!$B:$B,'Manager''s Dashboard'!E9)

So the user selects first criteria in L2, then second criteria in L4. The result land nicely into the cell. However I'd like to add an option to select all...

 

[Aladin Akyurek]

In which cell is Joe?

 

[rthompson55125]

In which cell is Joe?

Hi, Joe would be in B:B identifying user's entries, D:D is another critiria, let's call it morning or evening transactions. However, B:B is the key identifyer to select what user to display . Note I am calculating spend transactions! Thank you!

 

[Aladin Akyurek]

Hi, Joe would be in B:B identifying user's entries, D:D is another critiria, let's call it morning or evening transactions. However, B:B is the key identifyer to select what user to display . Note I am calculating spend transactions! Thank you!

I'm asking which is the criterion cell that would house Joe? Didn't you say: "So the user selects first criteria in L2, then second criteria in L4. The result land nicely into the cell. However I'd like to add an option to select all..." All in where?

 

[rthompson55125]

I'm asking which is the criterion cell that would house Joe? Didn't you say: "So the user selects first criteria in L2, then second criteria in L4. The result land nicely into the cell. However I'd like to add an option to select all..." All in where?

My apologize for not being clear as this my first posting. Appreciate the patience.

Let me start over. L2 had a pick list to choose from: Joe, Barb, Timmy, All. The source is on another tab that tracks transactions, those transactions are listed and in Column A:A (on another tab) they are assigned a transaction that is assigned to them, although there really isn't an "All", so Column A:A only has their names. I'd like to be able to sum ALL if selected.

Thank you

 

[Jonmo1]

Try

=SUMIFS(Transactions!$AB:$AB,Transactions!$A:$A,IF('Manager''s Dashboard'!$L$2="All","<>",'Manager''s Dashboard'!$L$2),Transactions!$D:$D,'Manager''s Dashboard'!$L$4,Transactions!$B:$B,'Manager''s Dashboard'!E9)

 

[rthompson55125]

Thank you very much. It worked and I appreciate helping out!