A2:A5 = 100, 200, 300, 400 respectively.
B2:B5 =      5,  15,   30,  40 respectively.
A1 and B1 are both blanks.
=SUMIF(A2:A5,"300",B2:B5) yields 30.  Okay.

I have a master spreadsheet, how do I create a copy of it?

I am quite lost and welcome some logical explanation.  This is what I have done.
Click http://www.contextures.com/xlPivot07.html and download the tiny sample file.
Select the SalesPivot sheet (the one one screen when the file is opened).  Drag all the fields including page field ...

A1:  The Olympics
B1:   2008
C1:  =A1&CHAR(10)&B1
I expect the result in C1 to be

I set up a custom cell format to bring forward (1.) the sum a cell, which is
a DATE and (2.) the sum of a different cell, which is a %.  However, the
program is taking the luxury of converting the -% data to a positive %
number.  Why is this, and how can I correct it?

Can someone give me an example when we need to use
=CELL("contents",A1) instead of =A1?
Thanks.
Epinn

I have two EXCEL 2000 workbooks( Estimates.xls and Prices.xls).
Workbook 'Estimates.xls' has 1 worksheet with empty cells (C&D) that need
populating if columns A&B are filled in, see below.
(snapshot of ESTIMATES.xls)

HELP I seem to be missing the top of my excel page I have no arrows up,down
either at right of document PLEASE PLEASE HELP URGENT I need data
painstakingly entered

I went to message board, but the referred sites at MS no longer available.
a) The Excel 'Fill' color is not working at all.
b)  And, the 'Font' color seems to be locked somehow. No matter what color I
click, it returns to black, and will show the auto black at the top of the

I can't get nested subtotals to work.  With totals set to appear above the
data, the very first "sub-subtotal" appears above the first "sub-total".

I have 51 sheets in the same workbook.
The front sheet is a summary sheet of the 50 behind.
Each sheet has a list of codes with a value next to it, but the same code is
not on the same line in each sheet.

I posted a topic yesterday but it has yet to show up and no longer have
those notes... so  bear with me.
I am wanting to have inside a cell:
REV: username - now() random-8-characters

Firstly, I not looking for a Sudoku solver as there are many about for which
I admire the programmers skills in creating.
I like to solve the puzzles myself and to do them I manually write in to
each blank box the possibilities, however, most newspapers don't allow

I have 52 sheets in the same workbook.
Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets.
I would like sheet 52 to be an analysis sheet.
In the top corner of sheet 52 I would like to be able to put a code

I'm sure many of you have seen the performance numbers published by most
mutual fund companies for their different funds.  They usually show MTD
(month to date),  YTD (year to date), 1 year, 3 year, and 5 year percentage
returns.