Conernesto
asked on
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)
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)
ASKER
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
=DSUM(C3:D8,2,A1:B2)
With new criteria in B1:B2
=SUMIFS(D3:D8,C3:C8,A2,D3:
No need for criteria headings and not such a rigid structure as DSUM
Dsum.xlsx
ASKER
This looks like it will work. I will close this question after I try on my worksheet.
Thank you.
conernesto
Thank you.
conernesto
You can replace the cell reference to the greater than zero with ">0" (including quotation marks) in the SUMIFS
ASKER
Do I replace ">0" in the formula? If yes, how?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK
Have you considered SUMIFS (2007+) or SUMPRODUCT (2003&Earlier)
Attached example shows simple use of >0 for positive sum.
Example.xlsx
Example.xls