Is there a way to feed an array of 'IF' function results into a 'Sumproduct' function? For example something like this =sumproduct(--(If(CODE(a1:b12)=32,0,a1:b12))). I want sumproduct to add up all the 0's and the values in the other cells. I have modified my question and added an example.
Bookmarks