I have a file in which I use to enter the details of money collected based on their Account numbers for everyday.
In my sheet
Cell A - Serial Number
Cell B - DATE
Cell C - Account number
Cell D - Money
Cell G - DATE
Cell H - Should be sum of the money collected on the date G.
I'd like to have formulas like VLOOKUP or MATCH to finish this job.
My sample file has been attached.
Somebody please help me.
Thanks in advance.
use in
H2
=SUMIF(B:B,G2,D:D)
and copy down
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you so much.
This is what I was looking for.
It really helped me a lot and made my job easier.
your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks