VLOOKUP HELP

Solved/Closed
PAUL - Jan 3, 2010 at 03:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 3, 2010 at 09:47 PM
Hello,
I would be very thankful if anybody solve my problem which exactly need. 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 datas (date, name, debit/credit) above found in sheet1. I need the formula how I could get the sum of debit/credit in another sheet. eg:

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

Please help me!!!
regards
Paul

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 3, 2010 at 09:47 PM
in sheet2 B2 paste this formula

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

and hit enter key
6