I am trying to apply a sumpoduct formulae to a range of data.(alpha not
numeric)I get a N/A result. I think the answer is because the data is
"not normal".

The data is as a result of a filter on a another sheet, then copy and
paste visible cells into this sheet. I can tell the data is "not normal"
cause when I press arrow and control down or control up it does not stop
at the first instance of data, but goes all the way to the end of the
sheet (atcually to the last number of the PREVIOUS filtered sheet). Also
when I press delete on an empty cell, I get the hour glass for a second,
and the data in the column on the left hand side then extends into the
coloumn (previously it didnt)

I have tried copying and pasting values, copying and pasting 1 (as a
multiplier), finding and replacing "", but to no avail.

Any ideas will be MOST welcomed.

Thanks

D





*** Sent via Developersdex http://www.developersdex.com ***