Add amounts in a column based on transaction date in another column

J

jonco

I have a spreadsheet with 6 columns Customer No, Name, Amt, Date, By and
Note. It could have as many as 5,000 rows.
What I want to be able to do is have a cell that displays the total
transaction amounts for the current day (all transactions done today) and
another cell that dispalys the total amount transactions for Yesterday (day
before today.)
I'd also like to be able to input a date and get the total transaction
amount for any given date.
Date column is D and Amount column is C.

I know this isn't too dificult but my programming skills arent the
greatest. I appreciate any help you can give me.

Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing transactions based on date 2
Personal Ledger Problem 2
Pivot table based on amount ranges. 4
help with database 2
Problem with group by query over date range 1
If Formula and Dates 4
query result in relation with table 4
Formula to Find Latest Transaction Date and amount for a customer 6

Top