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?

cuz this function does NOT take whole columns.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H." wrote in message
...
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?

until xl2007. Then whole columns are ok.

Don Guillett wrote:

cuz this function does NOT take whole columns.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike H." wrote in message
...
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?

--

Dave Peterson