Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the cell reference
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the cell reference
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 "XAT" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the cell reference
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 "FloMM2" wrote: 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 "XAT" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to change change cell reference to Absolute reference? | Excel Worksheet Functions | |||
change change cell reference to Absolute reference | Excel Discussion (Misc queries) | |||
change last cell reference | Excel Discussion (Misc queries) | |||
Cell Reference Change | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |