sumproduct

[christinmj]

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

 

[Hui]

Chris

Try,

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