I have a worosheet with cokumns for 20+ payments. These columns track the date it was entered for payment, amount, check date, record number for each of the 20+ columns.
In another sheet, I want to sum the amount entered and the amount paid by
line.
Meaning, row 2 on sheet 1 ties to row 2 on sheet 2 so I don't need to do
lookups
or sumif type. At least I don't think so. :)
So, I have a formula that sums all the amounts entered but now I need one to
sum
the amounts is there is a check date and record number.
I've attached a file as a sample that I think will help you to understand.
Thanks for everyone's help.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Need amount paid.xls
Description: MS-Excel spreadsheet
