Earlier NBVC help me solve a Summing problem, Now that I have that solved I was hoping to be able to do one more thing.
If a value isnt in the array below for the VLOOKUP I wanted to have the function sum those items as long as coulmn AE has an "x". Basically it is summing all the values that contain an "x" in column AE and doesn't match any value in the VLOOKUP Array from column AD (what I would call "others").
Formula to cover those that appear in the Array:
=SUMIFS($X$3:$X$205,$AD$3:$AD$205,VLOOKUP(A210,Expected,4,FALSE),$AE$3:$AE$205,"x")
Bookmarks