Hi Excellers,
How may I correctly write the formula below:
like this to create dynamic OR statement in years:=SUM(SUMIF(G5:G10,{2014;2015},E5:E10))
For some reason, it will not allow me to insert formulas within the brackets.=SUM(SUMIF(G5:G10,{YEAR(TODAY())-1;YEAR(TODAY())},E5:E10))
Thank you for your time...
Bookmarks