G
Guest
I just figured out why sometimes a sumproduct function would work and
sometimes why it would return #NUM instead. If one of the elements is stated
like this: ($A:$A = "XYZ) it will fail, whereas ($A1:$A65537="ABC") then it
works. Anyone know why? And is there an easier way to state an entire
column in a formula in a cell?
sometimes why it would return #NUM instead. If one of the elements is stated
like this: ($A:$A = "XYZ) it will fail, whereas ($A1:$A65537="ABC") then it
works. Anyone know why? And is there an easier way to state an entire
column in a formula in a cell?