Change the cell reference

  • Thread starter Thread starter XAT
  • Start date Start date
X

XAT

Hello,

Is there any way we can change the default cell reference when forumlae is
copied to the susequent cells.

Below is the example where i need to roll up the week day information to the
weekly. So, if need to obtain week-1 count i used countif(<week-1 range
(Mon-Fri)>,1) ==> resulted as value 4, now for second week if i copy the
above formulae it would paste as countif(<Tue-Mon>,1) ==> 3 which is not the
desired result because of incorrect range, Tue-Mon.

Is there any way i can alter the default increment (1 in this case) in the
cell reference when the formulae is copied in to subsequent cell from the
start.

Weekday Value Week Count
Mon 1 Week-1 4
Tue 1 Week-2 3
Wed 1
Thu 0
Fri 1
Mon 0
Tue 1
Wed 1
Thu 1
Fri 1


Example
 
XAT,
If I understand you:
You want to count the values from Mon thru Fri.
Then you want to count the values from Tues thru Fri.
Then you want to count the values from Wed thru Fri.
etc.....
The formula I came up with is:
"=COUNTIF(B2:B$6,">0")"
hth
 
Thank you for response on this, I want to count every time Mon-Fri only,
first week Mon-Fri, next week again i need to start from next Mon-Fri and so
on.

Regards,
XAT
 
Back
Top