Can you sum all the amounts that occur on certain dates?
Posted by Jeff on February 21, 2001 11:42 AM
I have a table that lists a bunch of investments. This table has 2 columns - the Date of the investment and the Amount.
What I want to do is have a designated cell report the total of all the investment amounts that occured on a specified date. Note: I do not want to filter the data to only show the investments occuring on a particular date - it must simply be the total amount for the date's investments provided in the one cell.
The requested date will always change and the table will constantly be growing.
Is there a way to do this? Any help is much appreciated!