I need to sum different criterias.  I have three columns. A, B, and C.
Sample
1234     1235     20
1235     1231     15

How do I conditional format only text that is upper case?

I have this massive file with some 60 odd tabs and I was wondering what
function would be the best way to approach gather data from each of these
tabs and putting it on the first sheet.  Each of the tabs are structured the
same way so I would be grabbing simply the date and the ...

Can anyone suggest a more flexible substitute for the following formula? It
effectively counts the number of non-blank (>0) rows in an array. This
formula is limited, however, in that every column requires a separate
statement. I would like to find a function that could handle an ...

I have five columns shown below, with sample values after the colon
(Col F) Today's Date: 04-28-06 {this will be using the =TODAY() function}
(Col G) Contract Date Signed: 03-28-06
(Col H) Duration (Months): 12

I have a column of numbers for which i need to average every 12 rows(i.e
average rows 1-12, 13-24, 25-36, etc).  It is two years worth of data (730
days) with 12 entries per day.  I need the average daily readings for each
day.

I have this simple function:
="Sales of: " & NOW()
But this way the date is appears with that Excel code  like
33046,30184. I wanted to show 04/28/2006.

In previous versions of excel you could sum figures without a formula and see
the running tally in the bottom right of the screen.  For example:
Column A        Column B     Column C
  20                       30           10

I want to 'blanket' copy one sheet to another in seperate workbooks creating
links so one updates the other, but I don't want to reference each cell and
also I don't want zeros in where blanks are in the source data sheet.
Thanks

I need to create a formula that will calculate a tiered 401k match based
upon the amount being contributed.
The match formula is 100% on the first 3% of an employee's contribution, and
50% on the next 2% contributed.  

If I use the Excel Functions box for a formula such as the financial formula
PMT is there a way to see how Excel actually uses all the elements of the
formula?  I am using Excel 2003.

I have a report setup where I paste data into a range of cells.
The cells have a conditional formula to compare the cells to a list of cells
in column A.
I use this report on a monthly basis, and the list in column A changes every

BIN2HEX is acting really wierd.  BIN2HEX(511) works fine.  BIN2HEX(512)
returns a #NUM! error.
Also, can't figure out how to input a hex number into the worksheet.  If I
input '43E2', the worksheet will NOT recognize this as a hex number.  Is

Can I use INDIRECT function nested with other function, for example with
SUMPRODUCT,
like : SUMPRODUCT(INDIRECT(..);INDIRECT(..))
I have tried but it doesn't work for me, am I wrong in syntax, or..

Is it possible to include the first row field for all data in the table with
multiple rows?  For example:
                                A              B
June    Mike               5               8