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.
Please Login or Register to view this content.
I want to change the formula to add only positive numbers.
Please helo me change the above formula.
Thank you
Riz
Last edited by rizmomin; 05-16-2013 at 05:31 PM.
Try
=SUMIFS(Inv_Sum!$P$2:$P$12437,Inv_Sum!$P$2:$P$12437,">0",Inv_Sum!$D$2:$D$12437,$A131,Inv_Sum!$A$2:$A$12437,$A$1)
=SUMPRODUCT(--(Inv_Sum!$A$2:$A$12437=$A$1),--(Inv_Sum!$D$2:$D$12437=$A131),(Inv_Sum!$P$2:$P$12437>0),(Inv_Sum!$P$2:$P$12437))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Jonmo1:
Your formula works great for me..
Thank you so much
Riz
wasn't the question about sum product?
Hi Martinwilson:
Yes it was sum product in the formula.
Using the formula you created would give zero instead of $3890.19
Can you please check the formula and modify again.
Please let me know if any questions.
Thank you
=SUMPRODUCT(--(Inv_Sum!$A$2:$A$12437=$A$1),--(Inv_Sum!$D$2:$D$12437=$A131),--(Inv_Sum!$P$2:$P$12437>0),(Inv_Sum!$P$2:$P$12437))
Hi Martinwilson:
Yes, now the formula works.
You are genius.
Thank you so much for your great help.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks