I have an inventory spreadsheet and I am trying to figure out how to add
column "E" and column "F" then at the same time multiply column "D" to get a
total in column "I".
     E F  D    I

I am new to aray formulas and im finding them very handy however i a
finding that they slow the spreadsheet up alot and calculations no
take some time to run.
Is this normal and is there anything i can do/try

I'm creating a price list and need to have an average price list out of
6 prices on the end end of each line for about 1500 lines.
Individually doing this would take a long time, any tips?

I have several spreadsheets that I need to increment a column each time
information in another column changes. Using example below, each time
program changes I need the count column to be incremented. I don't want
to use autofill as I have to do this every month and several sheets ...

I have a 3 Pivot tables, each with 2 Row fields and several data
fields.  All 3 tables are together are 1 page wide.  However they are
several pages long.  Each table does not break into subsets at the same
point.

I am trying to determine if it is possible to convert a 6 digit number into
a week - for example:
050525 = yymmdd = 2005, May 25th
and I want my field to determine what the week number of the year is...

<disclaimer>
I know my question has been asked and answered before.  But in nearly
two hours of web searching, none of the answers I found were
satisfactory.  This should be trivial, yet it doesn't appear in a

I am trying to convert the text in cell A2 which is LAST NAME, FIRST NAME to
convert to FIRST NAME LAST NAME - No comma.  I got pretty far with the
formula below.
This is what it looks like: Tackett, Raymond

One cell has the content
abc;def;ghi;...
I want a formula contruct to break the parts up as separated by the
semi-colon to their own cells.  So

I have Excel 2002.
When I try to add a border to a cell, the color defaults to light grey
instead of black, even though the color control under Format>> Cells>>
Border  says "Automatic".  How can I change the default color for

I have an array that works fine in its current form.  What I would like
to do however is add an additional parameter that use less than.
=SUM(IF($D3&Lists!$A$32=Rep&Year,Revenue)).  What I want to do is add a
month parameter for examples that would only add where the month is

I have a bar chart that shows projected and actual numbers for four quarters.
I'd like to label each pair of bars with the PERCENTAGE between the projected and actual numbers for each quarter, rather than the actual number each bar represents.
Is there a way to do this based on a ...

Printing on 4x6 Label , no form feed ( paper feed) on printer .
on nec p6300 printer

If I have multiple rows of data on a worksheet and on another worksheet
I want various counts of rows that have certain things in common, how
would I do that?  Thanks.

When I type 01243 32186 (telephone number) it is left aligned in the cell and
exactly as it is typed.  As soon as I move the cursor away from that cell,
the telephone number flies across to the right in the cell and the '0'
disappears so it reads 1243 32186 and is right aligned ...