When I try to use =SUM (  :  ), to get a total for amounts which were
calculated using formulas referencing amounts on another sheet, nothing
happens (I do not get a total).

I have a worksheet with a "weekly total" on several locations (34 rows apart)
that needs to be put into a second worksheet in a column next to the week
ending date.  The formula being used is simply "=worksheet1!C34" and the next
one will need to be "=worksheet1!C68" and so on.  ...

I have a complex formula that I can't seem to find the right combinations of
If/then and lookup statements.  I also am having difficulting searching for
the right solution as to what I am trying to accomplish.
I need to be able to give discounts to volume users of a copy machine ...

I have a single column of data. There are several occurences of the
text "PAX" and always there is a number in the cell below. Is there a
simple formula I can use to sum all these numbers up? Tried a sumif
but no luck.

I need to have an excel file 'expire' 3 months after first installation.
Is it possible to build something into the program so that it will read
the date on first use and stop functioning after a set time , perhaps
with a popup too?

I am working on a 20 page worksheet and I need data copied from worksheet 1
to 2 -3 etc. I know the formula to copy from sheet 1 to sheet 2
((=week1!m35) .
What I wish to know is when I copy work sheets the formula on worksheet 5 is

total of a column where the text is "X" and the name column is not blank.

I would like to add a column for projected sales into a pivot table.
Formula would be Grand Total/(month sales are through)*12.
I am running into problems because when I try to add the column on top
because I have the MONTH column on top already the pivot table wants

Hello--
I have an array of values (below). I'd like to do a conditional format to
highlight those values that comprise the top 30% of the sum.
I know I'd probably use a formula in the conditional formatting but not sure

I have a reference in the first line of my spreadsheet on a sheet
referring to another sheet i.e
          A                            B
C                            D

I just download template budget, excel 2007, and after I opens it, I can not
insert columns..How can I do it

I AM WORKING ON A SPREADSHEET TO TRACK MONTHLY SALES. I WANT TO DO AN IF
STATEMENT THAT WILL TELL ME IF SALES ARE UP OR DOWN COMAPAIRING THE LAST
MONTH TO THE PRIOR MONTH. I KNOW HOW TO DO THE IF STATEMENT. BUT WHAT I DONT
KNOW HOW TO DO IS SET IT UP TO UPDATE EACH TIME A NEW ...

My excel's formula is not currently funtioning automatically.
An example is when I'm copying a formula to be pasted in multiple cells
either any direction, it only gives me the amount that I copied although the
formula bar shows the formula copied refers to different cells and ...

I'm making a 5 page doc that will be used 2 times a week.  I need to put the
date on each page and would like to type it once on the first page and then
have it go onto each page in the same place.  Thanks,

I have to maintain our representative database & send it to our head office
lilke
       A            B                  C                      D            
     E