=SUMIFS($I$8:$I$1996,Reo!$D$8:$D$1996,Options!$E$12,Reo!$E$8:$E$1996,Options!$AH$13,Reo!$F$8:$F$1996,Options!AH14)-SUMPRODUCT(I8:I1996*(H8:H1996=AJ8))
See this formula. I want to minus certain variables that dont need to be included. As per AJ8 - if I add more (I8:I1996*(H8:H1996=AJ8)) for different cells it doesnt appear to work.
Thanks
See this formula. I want to minus certain variables that dont need to be included. As per AJ8 - if I add more (I8:I1996*(H8:H1996=AJ8)) for different cells it doesnt appear to work.
Thanks