Excel - Formula to get sum of debit/credit
Arow B C D 24/01/2018 PAYMENT RECEIVED 000000000L1625996828275 Credit 2 25/01/2018 PETROL TRXN FEE RVRSL EXCLUDING TAX Credit 2 3/1/2018 SWAGATH DE ROYAL HYDERABAD IN Debit 10 4/1/2018 INDIAN RAILWAYS CA INR HTTPS://WWW.I IN Debit 10 5/1/2018 BAR ONE HYDERABAD IN Debit 10 5/1/2018 BAR ONE HYDERABAD IN Debit 10 Now want to get sum of credit & debit like below Credit 4 Debit 40 Ans: Formula : = SUMPRODUCT ( ( $C$2:$C$222 = Credit ) * ( $D$2:$D$222 ) )