lzweifel
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 213
Hello all, happy hump day!
I have columns for 30days past invoice date, 60days past invoice date, 90days etc.
The formula is set to record a date according to todays date vs invoice date and puts that date in the appropriate column (30-45-90-120). There is a running total for invoices until they are paid, but I am wondering what conditional formula I might use to sum the columns... so for example, there are 3 invoices which sit in the 45 day column... I want to know what the total of those invoices are.
Sorry if this is confusing.
I have columns for 30days past invoice date, 60days past invoice date, 90days etc.
The formula is set to record a date according to todays date vs invoice date and puts that date in the appropriate column (30-45-90-120). There is a running total for invoices until they are paid, but I am wondering what conditional formula I might use to sum the columns... so for example, there are 3 invoices which sit in the 45 day column... I want to know what the total of those invoices are.
Sorry if this is confusing.