So I've highlighted my cells for where I want to replace a string in my if statement with another string.
for example,
=SUMIFS($I$3:$I$27,$E$3:$E$27,"*blue*8*",$F$3:$F$27,"<"&DATE(2017,1,1),$G$3:$G$27,">="&DATE(2016,12,1))
so i use alt+f and look up "*blue*8*" and replace it with "*white*8*" but it's not replacing the formula properly.
I'm guessing it has to do with the wildcards?
How would I write this out so it actually works?
for example,
=SUMIFS($I$3:$I$27,$E$3:$E$27,"*blue*8*",$F$3:$F$27,"<"&DATE(2017,1,1),$G$3:$G$27,">="&DATE(2016,12,1))
so i use alt+f and look up "*blue*8*" and replace it with "*white*8*" but it's not replacing the formula properly.
I'm guessing it has to do with the wildcards?
How would I write this out so it actually works?