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

 

[Jonmo1]

You're welcome.

 

[rthompson55125]

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)

That worked great! Could I ask one last question? If my SUMRANGE $AB:$AB was zero, how could I add another if/than that would cite another cell 'Manager"s Dashboard'!E10 if AB:AB was blank?

 

[Aladin Akyurek]

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

At last!...

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

I'd prefer the criterion test rather as...

IF('Manager''s Dashboard'!$L$2="All","?*",'Manager''s Dashboard'!$L$2)