Hey there, anyone know how I can do the following? My guess is I would use Index Match but not sure how to involve the date aspect.
I need to sum some values that match by a common symbol under two different headings, but only if they fall within the same calendar year.
So. If sym A matches...