| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add amounts in a column based on transaction date in another column
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum data in 1 column based on date info in another column | Excel Discussion (Misc queries) | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
| Summing one column based on date in another column | New Users to Excel | |||
Hybrid Mode
