• Status: Solved
• Priority: Medium
• Security: Public
• Views: 395

# Excel Formula -DSum formula

Hi, I am using a DSUM formula to add the amounts from CompanyA if it matches Cell A1 and A2. How can I modify the formula so that it only adds the amounts if the amouts are positive ? Below is a sample. On the last row I have the formula that I am using.

A                             C                D              E           F
1CmbGrp                  Current            Want
2US
3            CmbGrp      CompanyA
4                  100
5            US      300
6                  -200
7                  300
8            US      -100
9Total Positive US \$                  200            300
10
11
12            DSUM(D3:E8,2,A1:A2)
0
Conernesto
• 4
• 4
1 Solution

Commented:
Could you post in a dummy workbook.

Have you considered SUMIFS (2007+) or SUMPRODUCT (2003&Earlier)

Attached example shows simple use of >0 for positive sum.
Example.xlsx
Example.xls
0

Author Commented:
Attached is a dummy workbook. The answer that I want in cell D9 is 300

conernesto
Dsum.xlsx
0

Commented:
Here you go.. with 2 possibilities...

=DSUM(C3:D8,2,A1:B2)
With new criteria in B1:B2

=SUMIFS(D3:D8,C3:C8,A2,D3:D8,B2)
No need for criteria headings and not  such a rigid structure as DSUM
Dsum.xlsx
0

Author Commented:
This looks like it will work. I will close this question after I try on my worksheet.

Thank you.

conernesto
0

Commented:
You can replace the cell reference to the greater than zero with ">0" (including quotation marks) in the SUMIFS
0

Author Commented:
Do I replace  ">0" in the formula? If yes, how?
0

Commented:
The formula would become:

=SUMIFS(D3:D8,C3:C8,A2,D3:D8,">0")

or
=SUMIFS(D3:D8,C3:C8,"US",D3:D8,">0")
Dsum.xlsx
0

Author Commented:
OK
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.