SUMPRODUCT Problem

[Andrew Mackenzie]

I would appreciate any thought on this curiosity.

In A1 I have a number - 25,000

In B1 I have another number 0.95.

I also have a cell with the formula =SUMPRODUCT(A1:B1)/SUM(A1)

Usually I have a number of rows with similar numbers in the respective
columns and the formual expands to accomodate these rows.

For some reason the formula gives me the result 1.00 when it should clearly
be 0.95.

The problem does not seem to arise when there is more than one row.

Any thoughts?

 

[Peo Sjoblom]

try

=SUMPRODUCT(A1,B1)/SUM(A1)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Andrew Mackenzie]

Thanks - works fine.

try

=SUMPRODUCT(A1,B1)/SUM(A1)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)