any help much appreciated

How do I get a formula to copy and keep same cell range? example:
=SUMIF('Flash Update'!B1:B20,"PE",'Flash Update'!D1:D20)
when I copy it to another cell it comes out as:
=SUMIF('Flash Update'!B2:B21,"PE",'Flash Update'!D2:D21)

Can I hide a worksheet page so it is not viewed by others but is still able
to provide data to other worksheets? If so, How and how would I unhide it
when I need to view it?
Thank you,

I have created a file in Excel and have copied data into w word file .  The
word file reopens and correctly displays the data.   However the Excel file
only opens as read only sothat I am unable to to amend or transfer additional
data.  Help tells how to create read only files ...

Lets assume row 5, column A contains some important title.  How do I
keep a row 5 stationary such that when the user scrolls down rows 6
through XX (where XX is some number up to max) will slip under (or at
least so it seems) row 5?

If I have cells B4 to B250 filled with numbers and I want to sum every seven
cells (B4:B10, B11:B17, etc...). How can I do it such that in I4 is the sum
of the 1st seven, I5 the sum of the second 7, and so on.
I know I can do it manually but I have so many to do that I really need ...

I am using =AVERAGE(IF(F30:F69=3,O30:O69,"0")). Also using CSE to {}.
In Column F30 to F69 i have value 1-10. Some cells are blanks. In Column O30
to O69 I have a calcuation based on Column L and N.  When there is a Number 3
in Column F, raw30-69 and some value in Column O raw ...

 Iam new to this group.  I have 1025 mail id's. I want to add one
comma(",") end of each mail ID..Plz. let me know how to do it?
Thanks in advance..
Regards,

Is there any way I can adapt how a formula copies across, apart from doing it
manually?  I want part of the formula to change.  For example Sheet1!$a2 when
copied across will show Sheet1!$a2 and so on. I want it to show Sheet2!$a3
and then Sheet3!$a2.

I need to be able to open up new workbooks, using different windows

Dear All
I was orginally helped with a similar problem by Sandy Mann but I have come
to grief again. Can anybody give a formula that can do the Business
In b8 I have ' date details'!c5

How do I format to show lb & stones eg 24lb = 1st 10lb

I am trying to lookup values in one workbook from an array in another
workbook.  Can this be done?  I am getting #N/A errors from a perfectly good
vlookup formula.  I am assuming that it does not like the second workbook.  
If that is an incorrect assumption, let me know what else ...

MY FURMULA IS
=SUMIF(A1:A20,">=30-AUG",(B1:B20)) .THE PROBLIM IS THAT I HAVE TO CHANGE THE
DATE EVERY DAYS .WHEN I TRY TO INSERT C:1 ,=NOW(),INSTEAD OF 30-AUG" IT SHOW
WRONG.=SUMIF(A1:A20,">=C:1",(B1:B20))  

My spreadsheet is about 4000 rows. applied autofilter and it was not
recognizing data below 999