lookup a sum of multiple values for a single date

  • Thread starter Thread starter Mic
  • Start date Start date
M

Mic

OK I am trying to "user proof" (or Idiot proof) a report.
I have a small segment of this report that I am at a loss
to automate.
A little insight into my workbook as simplified as
possible:
The workbook is copied each month clearing values and
tracks company cash
There are multiple sheets in the workbook (10)
The Payment sheet has columns for each bank/GL account
There are several auto-deduct notes paid each month
These are summarized in a separate section of the Payment
sheet
I want to take each note payment and insert the total
payment(s) for each day in the appropriate column.
| K | L | M
-----------------------------
45 | Note|Day Due| Total Due
46 | 45| 1| 1,000.00
47 | 98| 2| 1,000.00
48 | 24| 3| 2,000.00
49 | 86| 1| 1,600.00
50 | 82| 5| 1,400.00

These need to be placed in column M from row 8 to 38 based
on date where row 8 is the first and 38 would be the 31st.
I know I can do this easily by just linking with a formula
in each appropriate date row like M8=M45+M49.
I am looking for a way to Automatically update per the
date in the table @ the bottom of the sheet when: notes
change due dates because of banking closed dates' or as
notes are paid off, and new notes are contracted.
Hopefully one of you folks can help me out with this.

Thank you
 
Mic,

What I understoud: you have a list of payments and the day
they were made. You want to add all the payments done in a
specific day. Did I get it right?

Sounds like you want to use a SUMIF, wich adds values in a
column if they match criteria in an other column. Look it
up in the excel help.

If you need further help please clarify your problem and
include an example of what you want.

Regards,
Felipe
 
You understood my question correctly. I had overlooked the
SUMIF function. Thank you for your help and insight.
 
Back
Top