I was going to use sumproduct but i cant get it to work so i am thinking it
is the onrg formula
I have two columns (well more really but only 2 in each calc).
Column A will be blank or have "C" in it

Is it possible to show the page number in a cell, instead of using "Header
and Footer"?
Thanks!

I am trying to set up a spredsheet to calculate my finances and i have some
direct debits that come up quartely and some bi monthly. I want the
spreadsheet to work out when.
So if one comes up today 31/3/07 and is due up in 3 months how can i get it

Please help, I have a line made up of a product Name, Cost of Product,Total
Units,and finaly total cost.
The total cost is a SUM of COST*UNITS.
I would like to have the resolt sent to a new square and kept as a running

I have a list in a file name abc.xls. I have defined the list with a
name say XYZ.
I have another file Summary.xls with a pivot table that I'm using to
give me a summary of that list.

I am trying to figure out how to return an empty cell with the
following formula:
=IF(A987>0,ABS(A987-B987)*10000,"")
It turns out that if A987<0, I get "VALUE" as an answer instead of

I have an attendance worksheet (A) and need to create an addition spreadsheet
(B) that will reference only the names from the first worksheet.
My issue is that WS A is constantly changing (names added/deleted) and WS B
needs to keep the rows matched up with the correct people (see ...

I was checking out a quote or a billing template and I needed a second page
to it in order to continue with the process.  How do I add a second page to
this?  I tried inserting a new worksheet, but it wasn't the same template?  
Thanks... Irene

I have a table in on worksheet called 'Team Numbers' that has the following:
CC    Team No    Deapartment    L4    L3
11    11    Finance                    9    2
14    4    IS                    4   

I've created a drop-down box in a spreadsheet and want to know if it's
possible to select more than one entry at once.
I have a list of manufacturers (i.e., Sony, Panasonic and NEC) with the
intention of having our resellers choose the manufacturers they use.  For

Hello, i want to lookup a certain price of a door in a price matrix that
matches criteria both in the left most column and topmost row that is between
2 values (for height) and 2 values (for width). So eg. i want to find the
price of a door which is 720 high X 450 Wide. I have to ...

I have 3 workbooks with 30 worksheets in each workbook.
I would like to consolidate all 90 (3x30) worksheets into a new workbook.
The new workbook would have 90 worksheets - keeping the original worksheet
names.

I have 10 open workbooks that each contain 30 worksheets.
Is there a way to have these 300 worksheets consolidated into one workbook ?
Thank you in advance.
Regards.

How can I draw a floor plan to scale so I can rearrange my bedroom furniture
before I move everthing?

Is there a way to produce multiple, non-repeating, intergers within a given
range?For example, generate 3 whole numbers between 1 and 20 (with an answer
such as 4,7,18)
I need help!  Thanks