SUMPRODUCT Problem

  • Thread starter Andrew Mackenzie
  • Start date
A

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?
 
P

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)
 
A

Andrew Mackenzie

Thanks - works fine.


Peo Sjoblom said:
try

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

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
Top