Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
It sounds though, that you need something like...
=sumif(D:D,"X",C:C)
If you need to do that for specfic clients, then something like this instead...
=sumifS(C:C,D:D,"X",K:K=K2))
Bookmarks