Hello:
I am using below formula successfully to sum P2:P12437 if it meets the criteria.
The vaule of the cell in column P is positive and negative.=SUMPRODUCT(--(Inv_Sum!$A$2:$A$12437=$A$1),(--(Inv_Sum!$D$2:$D$12437=$A131)),(Inv_Sum!$P$2:$P$12437))
I want to change the formula to add only positive numbers.
Please helo me change the above formula.
Thank you
Riz
Bookmarks