hi,
Q1. Don't use relative reference ie A1. use absolute reference ie $A$1
Q2. don't put sunday in the formula. put it in a cell like A1. Put the cell
reference in the formula then change the cell contents as/when needed.
not =COUNTIF(SHEET1!L1:L300,"SUNDAY")+...
but =COUNTIF(sheet1!L1:L300,A1)+...

regards
FSt1

"FC" wrote:

I'm just trying to COPY/PASTE a formula that will use the same range of cells
but I'm having problem finding out how ( I know it changes "relativately"
accordinly to the rows and columns). I want it to stay UNCHANGE! Tx. Excel
2003/ Windows XP.
Also Q2 in the same formula ( COUNTIF+COUNTIF+COUNTIF+...) is there any way
that I could change the criteria just ONCE and it will change in the whole
formula.
Ex.
=COUNTIF(SHEET1!L1:L300,"SUNDAY")+COUNTIF(SHEET2!L 1:L300,"SUNDAY")+etc...
I'like to COPY/PASTE always in L
and change just one time SUNDAY for MONDAY(after pasting it ) resulting in
MONDAY in all the countif ( about 12 ). Tx