Hi Everyone.  I've found tons of help in these forums in the past, and
am hoping I can again.  I've put together a spreadsheet for sales
tracking, and need to sum a group of multiple cells in multiple rows,
based on a value in a specific column.  An example:

I'm using Excel 2003 SP2.  I need a formula that will tell me how many times
tests passed across multiple platforms.  For instance, I have two columns; A
and B.  Column A contains multiple platforms, ie: oracle, unix, mssql2K5.  
Column B contains the results pass, fail, blocked.  ...

Example:
Normal Hours= 7:30am - 3:30pm MON-FRI.
Time & Half Hours= 3:30pm-6:30pm MON-FRI and First 3hours on a SAT.
Double Time= All other hours remaining.

Almost done with this but I'm stumped on the last remaining formula.  The
way this compensation plan will work is if reps are between 0-25% growth they
will get paid $100 per point, 26-50% $150 per point, 51-75% $200 per point.  
Growth is calculated monthly vs. a monthly #.  My ...

I am trying to create a workbook where sheet 1 can be viewed by all but to
click on the other sheet tabs and open the sheet you need to enter a
password. any ideas?

In Excel 97, I have cells in workbook A linked to cells in workbook B.  With
both workbooks open, is there any way to refresh workbook A so that I get any
new saved data entered in workbook B without closing workbook A and
re-opening it?  A hotkey or something like that?

I am trying to copy a formula from one cell to another but when I paste
it into the new cell the column and row number changes to the new
cell that I am pasting it into.  How can I make it stay the same as the
original ?

I am downloading data in to excel & need to format an amount field in to a
fixed 12 character field i.e. prefix with zeros to fill the 12 chars. NOW
comes the tricky bit, if the value is negative I need the (-) minus sign
prior to any leading zeros.

I want to write a macro that will update several cells that are calculated
using the solver function.  So far, the only way I've found to do this is to
update them one-by-one which is very tedious.  So I'm trying to write a macro
that will do this easily.  I tried recording the ...

I have an array of data with the first column and the first row being
sizes and the contents of the table being price.
I want to have a drop list where the user selects size a, size b and
gets given the price.

Is there any way to set up a custom format that will work in all Excel
spreadsheets like a global template?
Thanks.
Derek

I'm trying to set up a formula which will contactenate the contents of 6 or 7
cells.  I would like to be able to skip any blank values.
Using the following formula:  =a1&", "&b1&", "c1&", "&d1&", "&e1&", "&f1
Assuming cell b1, d1, and e1 were left blank, I would get the following:

Hi,
I would like to make a formula that allows me to have a number set
automatically according to the number i put in the previous cell.
Hope you understand what i mean

I'm sticking with the sumproduct as I found it quicker and easier than
a pivot table (I need to get this done sharpish!)
=SUMPRODUCT(($C$2:$C$10000=$R5)*(O$2:O$10000))
all I need now is how to do a similar thing but instead of a sum, just

Calculate the first 600 units @ 5c per unit, above 600 units calculate @ 5.8c
per unit