Strange Cell Behaviour...?

[Darin Kramer]

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 ***

[Bob Phillips]

Darin,

Post some sample data and the formula.

--
HTH

Bob Phillips

"Darin Kramer" <darin_kramer@hotmail.com> wrote in message
news:eLSwTFweFHA.3620@TK2MSFTNGP09.phx.gbl...
> 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 ***

[Darin Kramer]

Hi Bob,

Formulae is
SUMPRODUCT(((Sheet_b!$M$2:$M$7145=E25)*((Sheetb!$P$2:$P$7145=$E$3))))

In cell E25 = is either a H, M or L
In Cell E3 is Europe

Data
Column M is either H, M or L or blank
Column P is Europe, America, Asia or blank

(blank is the "strange cell" that I am referring to.

IS that what you meant?
There is no way of attaching the spreadsheet... is there..?

Thanks

D

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

[Darin Kramer]

I figured it out Bob, there was a N/A sitting in one cell somewhere
between row 1 and row 7145, once I deleted that it was all fine!!!

Thanks for your efforts.

D


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