formula issue, trying sum if

%3CLINGO-SUB%20id%3D%22lingo-sub-1687340%22%20slang%3D%22en-US%22%3Eformula%20issue%2C%20trying%20sum%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687340%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20any%20entry%20in%20Column%20D%20%3D%20employee%20AND%20any%20corresponding%20row%20entry%20in%20Column%20E%20%3D%20client%20ADD%20the%20corresponding%20row%20%24%20in%20Column%20I%20to%20Cell%20N7%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20employee%20is%20assigned%20dozens%20of%20clients%20and%20every%20sale%20is%20entered%20in%20order%20placed%20regardless%20of%20employee%20or%20client%2C%20so%20Column%20D%20is%20not%20sorted%20by%20employee%2C%20nor%20is%20the%20client%20Column%20E%2C%20its%20just%20chronological.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1687340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1687413%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20issue%2C%20trying%20sum%20if%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1687413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F799747%22%20target%3D%22_blank%22%3E%40John50%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJohn%2C%20from%20that%20it's%20not%20clear%20what%20is%20an%20issue%20with%20SUMIFS()%20formula.%20Perhaps%20you%20may%20attach%20small%20sample%20file%20without%20sensitive%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How can I:

 

if any entry in Column D = employee AND any corresponding row entry in Column E = client ADD the corresponding row $ in Column I to Cell N7,

 

The employee is assigned dozens of clients and every sale is entered in order placed regardless of employee or client, so Column D is not sorted by employee, nor is the client Column E, its just chronological.

 

Thank you,

John

 

 

2 Replies
Highlighted

@John50 

John, from that it's not clear what is an issue with SUMIFS() formula. Perhaps you may attach small sample file without sensitive information.

Highlighted
sys maint right now. will do it after reboot, thank you