I am trying to count a range of cells with multiple conditions. I know
CountIf will not allow two conditions; however, I am trying to count cells
with numbers in cells D2:d23 >9 and <20.
Please help!

This is the formula.
=IF(ISERROR(INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:2)))),"
",INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:1))))
This is on ...

When I try to revise and save an excel file that is on a flash drive, I get
an error message that says "the file or directory cannot be created."

Iwant to take an array and put the values into excel, i tried this but it
doesn't seem to work:
For i = 1 To 3
For j = 1 To 3

is there  a tool to calculate the sum of characters in a cell?

I'm new to using VBA, and am trying to create some code to run a daily macro.
The element of the code I'm stuck on is this: I import a daily excel sheet
where I need to have a simple formula that is:
=G1-Sum of "Range"+G2

Hi and thanks for the help. I am using Excel 2003.
I accidently used the wrong button and am hoping there is a fix. I need to
run a macro from a button.
I know that if I use the button (control button) from the forms toolbar the

I posted this question earlier today but I forgot to mention an important
item. The right click, assign macro choice is not available with the button I
used (the command button on the control toolbox.) Here's the earlier post.
I accidently used the wrong button and am hoping there ...

I'm sure that this will be a 'given' to most of you. I enter data into time
sheets daily
where i have to enter the job code as well as the job name ie: cell A1, the
job code in A2, I will type the job name . Is there a way to set this up so

Using Excel 2000, one numeric column has a number of comments in various
cells.  By pointing at the comment indicator I can dislay the comments and by
right-clicking over it I can delete the comments but I cannot edit the
comments.  This is with the exception of the last comment ...

well in my programs>office10> and i cant see excel in it or even access, so
what do i have to do to get them to work?

Contrary to the Excel 2000 help I am unable to create templates in the
"spreadsheet solutions" tab of the File New dialog box nor can I create new
tabs by making sub-folders in the direcctory where the built-in templates
reside ie "C:\Program Files\Microsoft Office ...

I am trying to copy a summary from one workbok to another.  How do I copy
with out absoute references to the source workbook?

I have the following code to create a UDF to calculate reciprocals:
Function Reciprocal(a)
   Reciprocal(a) = (1 / a)
End Function

What do I do to be able to change from one excel file to another excel file,
the Alt+Tab is not working.