Problem calculating
 

I am using 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 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

Problem calculating
 

You have an active thread elsewhere.

RonH wrote:

I am using 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 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

Problem calculating
 

What does that mean?

"Dave Peterson" wrote:

You have an active thread elsewhere.

RonH wrote:

I am using 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 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

Problem calculating
 

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

"RonH" wrote:

What does that mean?

"Dave Peterson" wrote:

You have an active thread elsewhere.

RonH wrote:

I am using 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 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