I have a simple but perplexing issue. See attached.
I am trying to write a formula that will sum by specific year but the date is a month, day, year format.
In this case, I am not allowed to add a helper column to break out the year. Is there a way to break out the year within date.
I have been trying to write either SUMIFS of SUMPRODUCT but can't get the syntax right.
Any feedback helps.
Thank you in advance.
Bookmarks