Problem calculating

R

RonH

I have the formula
=SUMPRODUCT((A2:A1000="2008")*(B2:B1000>0.01)*(C2:C1000>0.01)*(B2:B1000))/SUMPRODUCT((A2:A1000="2008")*(B2:B1000>0.01)*(C2:C1000>0.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
 
N

Niek Otten

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top