This should be simple, but it’s defeating me.  
Column A is a date, Column C is text, Column F is a number, and column G is
=IF(C10="Sales",F10/9,"")
In a separate worksheet, a SUMPRODUCT formula works fine to add up the

I'm looking for a formula (I think a formula, or some other way) whereby I
enter data in one cell on one worksheet and it simultaneously (or after a
keystroke or two) fills in the same data in a cell that I select on another
worksheet, all within the same workbook.  E.g., I type ...

I have several columns with zero values (0), and one column that contains
text value. On another cell, I would like to have a formula/function that
searches the entire row, and return only the text value. Any help is highly
appreciated.

I working on a baseball scoresheet.  I want cell Q2 to read the cell contents
in column H of the active row, as I move the active cell up and down the rows
(i.e., if active cell is Y36, I want Q2 to read data in H35 (note it is
offset by one row).)

Is it possible to obtain a quote on a CD using its CUSIP with the MSN
Money Stock Quotes add-in?
I've tried "/6616393", ".6616393" and just "6616393"; none of those
formats work.

I'm not sure if this question belongs to
microsoft.public.excel.programming or to here.
I want to do a simple recode operation.
in a matrix, I want to replace all values with a different code. For

I'm not sure where I should ask this, but thought I'd try here to see
if anyone knows what's up.
My spreadsheet has always been able to pull down 30 years of monthly
data (if available) using MSN's stock quote addin.  Just recently, I

I am trying to count the number of times both col a and col b have a 1 in
them on the same day. The spreadsheet has three columns A=Date C=1 or
blank,D=1or blank. The formula I have is this
=COUNTIF(C1:C367,"1")-COUNTIF(D1:D367,"1") but it is not giving me the

I have a Database listing that shows Sales of Products by location by
Date. I want to extract from this a total for each item by location by
Date
My parameters are in the following cells

I have a inherited worksheet that has the following names that are
global. Does anyone know what it would mean.
Name                                      Refers To
_Order                                      255

Is there a "Table of Contents" function for sheets, so
if I have Sheet1 cells with the names of the other sheets,
I click on the sheet name and it goes to that shteet?

Is it possible to move a Comment Box that is displayed, via code?
I have a number of sheets that I copy, but each time I do, the Comment
Boxes (on the Export sheets) are not in the position I want them.
Thanks

Hi, people...this is the second time I post this because the other one didn't
go through. I've added this formula to an Excel table:
=IF(B2=a,10,"IF(B2=b,8,IF(B2=c,6)))")
According to the nested-formula rules, this formula is well-formatted. It's

Excel on XP: I want the user to enter a sequence of random integers
into cell A1 and have the spreadsheet record their maximum. So in
B1 I placed the formula =max(a1,b1)
Excel alerts to a circular reference, but then resolutely maintains

I am currently using the formula
=SUMPRODUCT((--$J$5:$J$4000=$T$4007)*($AS$5:$AS$4000<0)*($AS$5:$AS$4000))
Column J is employee Id and could be formated as text or number ( raw file)
Column AS is formated as a number