• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sumproduct

christinmj

New Member
I gave formula in a cell that should sum which satifies multiple condition. Now I have to minus a specified value that satifies the specified condition in range.

For example =SUMPRODUCT((B4:B102="Deposit SBT")+(B4:B102="Bank Balance SBT"),D4:D102)


I have to reduce "withdrawal Amount" checks in the range B4:B102 and find the value from C4:C102.


Pls help


chris
 
Chris

Try,

=SUMPRODUCT((B4:B102="Deposit SBT")*(B4:B102="Bank Balance SBT"),(D4:D102))-SUMPRODUCT(1*(B4:B102="withdrawl Amount"),(C4:C102))
 
Back
Top