I have a list of balances in column 'A' and a list of expiry dates in column 'B'. in Column 'C' i have the end of month date for many years. i basically want to create a profile in column 'D' that will give me a total balance for all products that havent expired.
e.g. the balances in my list have expiration dates starting from 01/08/07 through to 01/08/15. so if the first date in column 'C' was 31/07/07 it would give me the total balance of everything in column 'A' but in the next cell down (column 'D') which has a date of 31/08/07 it will give me a total of everything excluding any balances with an expiration in Aug 07. etc etc.
im sure this can be done with a sumif but any help would be greatly appreciated.
e.g. the balances in my list have expiration dates starting from 01/08/07 through to 01/08/15. so if the first date in column 'C' was 31/07/07 it would give me the total balance of everything in column 'A' but in the next cell down (column 'D') which has a date of 31/08/07 it will give me a total of everything excluding any balances with an expiration in Aug 07. etc etc.
im sure this can be done with a sumif but any help would be greatly appreciated.