riskier4ra
Board Regular
- Joined
- Dec 5, 2017
- Messages
- 101
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 sym B check date for year and if the same sum the value of C1 & G1. If year in After does not match the year found in Before do nothing. Do not want to use SUMIF, would prefer to use SUMPRODUCT
Heading = Before
A1= Date
B1= Sym
C1= Numerical Value
Heading = After
E1= Date
F1= Sym
G1=Numerical Value
Thanks for any help you all can give,
Risk
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 sym B check date for year and if the same sum the value of C1 & G1. If year in After does not match the year found in Before do nothing. Do not want to use SUMIF, would prefer to use SUMPRODUCT
Heading = Before
A1= Date
B1= Sym
C1= Numerical Value
Heading = After
E1= Date
F1= Sym
G1=Numerical Value
Thanks for any help you all can give,
Risk