Problem calculating

[RonH]

I am using 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 criteria of year=2008 and that their is a value in both
the B & C cells. it then totals the valid cells in B and divides it by the
total of valid cells in C to give me a percentage. it works fine except i
have to click in the formula and hit enter to get it to calculate. I have to
do this in the manual mode only (F9 doesn't work either) becaus in atomatic
it returns a value of zero,
Please Help.....
Thanks,
Ron

 

[Dave Peterson]

You have an active thread elsewhere.

I am using 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 criteria of year=2008 and that their is a value in both
the B & C cells. it then totals the valid cells in B and divides it by the
total of valid cells in C to give me a percentage. it works fine except i
have to click in the formula and hit enter to get it to calculate. I have to
do this in the manual mode only (F9 doesn't work either) becaus in atomatic
it returns a value of zero,
Please Help.....
Thanks,
Ron

 

[RonH]

What does that mean?

You have an active thread elsewhere.

 

[RonH]

You were right. I had a sum going on at the end.
Thanks!!!