I noticed this formula in a recent post:
=SUMPRODUCT(--(C2:C6>0),--(F2:F6="QQQ"))
What does the -- signify?
Thanks

I've got two similar problems about loans which Excel
should be able to help me on.
1) In Texas, home equity loans can only be 80% of the
house value, and closing costs can only be 3% of the

I am trying to make a spreadsheet where I am trying to have the same
function down a column without having to write the formula in each cell
so I am looking for a way to repeat it.  For example:
cell B1 mult by C1 equal D1 so I would put the function in the cell D1

Hello can someone please help me find a link to a tutorial
regarding creating drop down menu's in Excel 2000
Thanks
Scott

I am working on a time sheet and I used the formula =MOD
(B1-A1,1) and now I need to add those cells together and
it is not giving the correct answer.  For instance I know
I worked 31 hours but it is giving the total of 16.

I wonder if we can intiate a macro by by proving a condition
e.g. If A1=1 then run the "XYZ" Macro, if A1=0 then do not run a macro
Can we apply the same in IF function
Thanks in advance

I am publishing an Access db report in Excel and
distributing it to several people for comments. I would
like to do something so that any cells they alter will
change colour for easy identification.

Can a foxpro database be imported into Excel?

    A          B
1  cat         100
2  horse     200
3  fish        100

Two problems have developed in only one worksheet file. I
can not format the date column. no matter what I chose
for date entering always comes up 1/1/00 second problem
has just occored dragging the balance on a check book

Is there a function like match() and index() that will
give me the row # of all matches, not just the first.  
thanks for the help.

I need to count the number of cells in a column of many
dates, that match a particular date, and it would be
easier to reference a cell with the particular date in it.
Instead of

I am looking for a function to get the tabname in a cell. If the name in the
tab is changed then automatically the name in the cell is adapted. Any
suggestion is much appreciated

I used the formula =MOD(B1-A1,1), in a few cells and now I
want to add those specific cells together.
It isn't letting me do it.
Help!!

I notice that Quatro Pro for years has had the ability to
adjust worksheet size.  So instead of having 256col x 65k
rows, you could switch and have 65k col x 256 rows, or
anything in between.  Does anyone know if Excel will one