Hi Everyone,
This is probably fairly simple to an expert but I for the life of me can't figure out how to do this.
So I've got a spreadsheet where accounts receivable are listed for each month. (example attached)
I need to keep a running total of one of the accounts for current year only.
So it needs to read the year in my date field and keep a running total of the account.
I know it's a SUMIF function reading the column with the year and summing on the value but I can't figure out how to actually read the year in my date column, extract the year and make a decision based on this year.
It needs to be dynamic, not hardcoded. And the date needs to be in the format in which I have it, i.e. "January 2019", can't have the year in a separate field=((
Thanks!!!
Bookmarks