I've tried finding a solution to this particular problem and have not found an exact fit.
I have a list of transactions from a checking ledger - with date, credits and debits. There are multiple transactions per day and, in some cases, no transactions.
I want to find the average daily spending amount for a given period (typically a month.)
Named ranges include:
tlogdate = transaction dates
tlogins = credits
tlogouts = debits
startdate = period start date
enddate = period end date
I've tried combinations of average, averageif, sumif / countif, sumproduct to no avail. Any suggestions?
Bookmarks