Problem calculating

R

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
 
D

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
Click to expand...
 

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

Similar Threads

Problem calculating 1
problem recalculating 1
Sumproduct and subtotal 1
Sumproduct with a twist 4
Count blanks by date 2
Defined Range Names in formulas 2
Sumproduct entire month from mmddyyy? 5
count all cells containing "Blue" 5

Top