A few words of thanks would be greatly appreciated.

Excel - Formula to get sum of debit/credit in another sheet

Latest update on October 15, 2014 at 01:01 PM by Jean-François Pillou .

MS Office Excel is called a spreadsheet application. The spreadsheet allows an individual to operate numerical statistics. One can perform various calculations and also analyze and forecast. In Excel, various kinds of statistical functions can be applied to the cells. One can also apply mathematical functions to the data. This could be simple, e.g. summing a data column, or complicated, like quantitative analysis. There are complex formulas to do the sum of data in the same or another sheet. The below article details a credit/debit summation formula. One must simply paste this into the cell where a result is desired.

Issue
Solution
Note

Issue

I would be very grateful if anybody could solve my problem. The details are given below:

DATE SCRIP NET(Cr/Dr)
19-Nov-09 LOKHSG -21025.40
20-Nov-09 LOKHSG -41024.68
24-Nov-09 RAJOIL 1208.81
24-Nov-09 TATACOFFEE 976.74
24-Nov-09 SKF -521.02
25-Nov-09 RAJOIL 1036.34
25-Nov-09 MMFIN 830.95
25-Nov-09 HEG 122.02
25-Nov-09 SESAGOA 269.47
26-Nov-09 BAYER 679.72
26-Nov-09 HEG 1552.68
26-Nov-09 ADORWELDING 13.15
26-Nov-09 ADORWELDING -156996.36
26-Nov-09 MONNET -42131.28
26-Nov-09 RAJOIL -68961.30
30-Nov-09 MONNET -210.90
1-Dec-09 WARRANTEA 1051.76
1-Dec-09 WARRANTEA -49708.47
1-Dec-09 TORRENTPOWER 587.44
1-Dec-09 MONNET -40476.41
1-Dec-09 RAJOIL 67770.92

So here are the data (date, name, debit/credit) above found in sheet1. I need the formula to get the sum of debit/credit in another sheet. E.g.:

SHEET2
DATE CREDIT/DEBIT
25-nov-09 (sum of debit/credit of the date).

Solution

In sheet2 B2 paste this formula

=SUMPRODUCT((Sheet1!$A$2:$A$22=A2)*(Sheet1!$C$2:$C$22))

And hit enter key

Note

Thanks to venkat1926 for this tip on the forum.

Debit credit balance formula excel
Excel formula for debit credit balance - Best answers
Debit credit balance sheet excel formula - Best answers
Formula if you have credit in one column, debit in next column ✓ - Forum - Excel
If formula excel date range - How-To - Excel
If cell color is then formula excel - How-To - Excel
Filter formula excel ✓ - Forum - Excel
Recurring date formula excel ✓ - Forum - Excel

This document, titled « Excel - Formula to get sum of debit/credit in another sheet », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel - If then statement for commission

Excel - Exporting data to another spreadsheet