Problem calculating
 

I have the formula
=SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000))
It verifies that the year is 2008 and that both cells in B & C have values
in them and it then divides all valid cells in B/C to give me a percentage.
It works fine except it will not recalculte unless I click in the formula and
hit enter. I have to do this in the manual mode only (F9 won't update it
either) because in automatic, it will return a value of 0 all the time.
Please help.
Thanks....Ron

Problem calculating
 

I can't reproduce that.
Very, very rarely, Excel looses its way in the recalculation chain.
You can rebuild that chain by finding and replacing all "=" signs with "="
signs or, in the last few versions of Excel (don't know exactly which ones),
by pressing CTRL+ALT+SHIFT+F9.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"RonH" wrote in message
...
I have the formula
=SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2: C10000.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B10000.01)*(C2:C 10000.01)*(C2:C1000))
It verifies that the year is 2008 and that both cells in B & C have values
in them and it then divides all valid cells in B/C to give me a
percentage.
It works fine except it will not recalculte unless I click in the formula
and
hit enter. I have to do this in the manual mode only (F9 won't update it
either) because in automatic, it will return a value of 0 all the time.
Please help.
Thanks....Ron