Formula that does not change the cell range

[Guest]

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!L1: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

 

[Guest]

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

 

[Guest]

Thanks. How can I change to absolute reference?( describe it for me please)
(that will be the question) as Q1.
In Q2 I cannot use your sugestion because from L1 to L300 the cells are
changing with the 7 days of the weeks in all the sheets in column L,that's
why I need to change it each time in order to count how many Sundays,
Mondays... I have.

 

[Fred Smith]

As FSt1 told you, an absolute address has $ signs in it, as in $A$1. For more
information, look up absolute addresses in Help.

 

[Guest]

Sorry. But my question is not even close to be answer, there is not addess
anywhere on my question? anyways thank you for trying both of you. Signing
out...

 

[Fred Smith]

I'm sorry to have interrupted you. I completely misunderstood. I thought you
were looking for a solution to your problem. But you just want to complain. So
I'll get out of the way so you can do so in peace.