Calculation help

[mjcdriscoll]

I am having a difficult time with a calculation. I took over someone else's duty who is no longer with the company. The calculation used did not account for entire columns & the data I need to pull fromhas grown larger than the calculation. When I hit "F2" to manually change the data array, everything works fine until I hit enter and then the result displays as 0.0%. When I hit the insert function button, the result shows as the correct number. I tried copying the format only from an adjacent cell, but this did not work. When I tried to undo my changes, the cell still displays as 0.0%


The original calc is:
=SUM(IF(cData!$T$2:$T$45998="Internal",IF(cData!$N$2:$N$45998=9,1,IF(cData!$N$2:$N$45998=10,1,0)),0))/SUM(IF(cData!$T$2:$T$45998="Internal",IF(cData!$N$2:$N$45998<>"",1,0),""))

The new calc is:
=SUM(IF(cData!$T$2:$T$65536="Internal",IF(cData!$N$2:$N$65536=9,1,IF(cData!$N$2:$N$65536=10,1,0)),0))/SUM(IF(cData!$T$2:$T$65536="Internal",IF(cData!$N$2:$N$65536<>"",1,0),""))

The calc from the cell below the cell I am working in:
=SUM(IF(cData!$T$2:$T$45998="Internal",IF(cData!$O$2:$O$45998=9,1,IF(cData!$O$2:$O$45998=10,1,0)),0))/SUM(IF(cData!$T$2:$T$45998="Internal",IF(cData!$O$2:$O$45998<>"",1,0),""))

I am not sure what I am doing wrong & would appreciate any help!

[NBVC]

These look like array formulas...

activate the cell with the formula in it by pressing F2... and then hold the CTRL and Shift keys down.. now press Enter.. you will see { } brackets appear around the formula..

then copy it down.

[NBVC]

You can probably replace with:

Please Login or Register  to view this content.

which doesn't require special entry... just ENTER will do

[mjcdriscoll]

NBVC - thanks a bunch! I knew I was forgetting something! I greatly appreciate the help! Now that I look at the addiational calc you provided, I can't believe I did not think of that. I use that calc on a daily basis.