software

I am using Excel 2003 and I need to write a function to select numbers in a
column based on two separate criteria and then sum those selected numbers. I

I need to enter more than 10 numbers to left of the decimal and more than 5
to the right of the decimal. Right now if I enter more than 10 numbers to the

i have to add cells evenly spaced, eg a1 a11 a21 ... a991
how can I avoid writting all references?

Hello There
Could Someone show me how i can create a macro to copy the activecell from,

In some cases Excel (2003 SP2) is displaying the formula in a cell, not the
results. The formula (say Concatenate or an IF) is correct and there is no

The following IF statement is not working:
=if(A1gt;B1, quot;quot;, B1-A1)

I need a cell to display a shaperange name. I'm stumped.--

I am trying to get excel to divide cell B3 by B5. I have been entering in
=B3/B5 and it keeps giving me #VALUE!. I also need to drag the formula down.

Any hours past 8 in a day is paid at 1.5
Any hours past 12 is paid at 2.0, except on Sat and Sun

2006-02-03-01.48.09.698000