Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a formula with different worksheet
I have a worksheet created that has "D" to represent Dayshift and "N" to
represent the nightshift. I would like to create a formula in the total cell on the nightshift worksheet that would indicate the total for both worksheets that have any nightshift personnel. Here is the formula I have for the total on both worksheets: countif(B5:B48,"N")*1 Now how do I add the night shift on the other worksheet |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a formula with different worksheet
Godzflava --
The easiest way is to add a similar expression, just selecting the cells on the other worksheet as you go. You'll probably end up with something like: =countif(B5:B48,"N")*1+COUNTIF('OtherSheet'!B4:B48 ,"N")*1 HTH "godzflava" wrote: I have a worksheet created that has "D" to represent Dayshift and "N" to represent the nightshift. I would like to create a formula in the total cell on the nightshift worksheet that would indicate the total for both worksheets that have any nightshift personnel. Here is the formula I have for the total on both worksheets: countif(B5:B48,"N")*1 Now how do I add the night shift on the other worksheet |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a formula with different worksheet
I tried COUNTIF(B5:B36,"N")*1+COUNTIF(DAY!B5:B48,"N")*1
AND i TRIED COUNTIF(B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND i TRIED COUNTIF(NIGHT!B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND ITS STILL NOT COUNTING THE ONES ON THE DAY WORKSHEET. HELP! "pdberger" wrote: Godzflava -- The easiest way is to add a similar expression, just selecting the cells on the other worksheet as you go. You'll probably end up with something like: =countif(B5:B48,"N")*1+COUNTIF('OtherSheet'!B4:B48 ,"N")*1 HTH "godzflava" wrote: I have a worksheet created that has "D" to represent Dayshift and "N" to represent the nightshift. I would like to create a formula in the total cell on the nightshift worksheet that would indicate the total for both worksheets that have any nightshift personnel. Here is the formula I have for the total on both worksheets: countif(B5:B48,"N")*1 Now how do I add the night shift on the other worksheet |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a formula with different worksheet
Godzflava --
Here's my formula, which works fine. (I didn't make the list as long on either worksheet, but that wouldn't affect whether it picked up the data or not.) =COUNTIF(B5:B30,"n")+COUNTIF(Day!B5:B30,"n") You'll note I didn't multiply the counts by 1, but that shouldn't make a difference either. If you're still having a problem, then paste your actual formula into the response and we'll take a look at it. "godzflava" wrote: I tried COUNTIF(B5:B36,"N")*1+COUNTIF(DAY!B5:B48,"N")*1 AND i TRIED COUNTIF(B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND i TRIED COUNTIF(NIGHT!B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND ITS STILL NOT COUNTING THE ONES ON THE DAY WORKSHEET. HELP! "pdberger" wrote: Godzflava -- The easiest way is to add a similar expression, just selecting the cells on the other worksheet as you go. You'll probably end up with something like: =countif(B5:B48,"N")*1+COUNTIF('OtherSheet'!B4:B48 ,"N")*1 HTH "godzflava" wrote: I have a worksheet created that has "D" to represent Dayshift and "N" to represent the nightshift. I would like to create a formula in the total cell on the nightshift worksheet that would indicate the total for both worksheets that have any nightshift personnel. Here is the formula I have for the total on both worksheets: countif(B5:B48,"N")*1 Now how do I add the night shift on the other worksheet |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a formula with different worksheet
thanks. It worked. I wasnt looking down the right column. thanks a lot
"pdberger" wrote: Godzflava -- Here's my formula, which works fine. (I didn't make the list as long on either worksheet, but that wouldn't affect whether it picked up the data or not.) =COUNTIF(B5:B30,"n")+COUNTIF(Day!B5:B30,"n") You'll note I didn't multiply the counts by 1, but that shouldn't make a difference either. If you're still having a problem, then paste your actual formula into the response and we'll take a look at it. "godzflava" wrote: I tried COUNTIF(B5:B36,"N")*1+COUNTIF(DAY!B5:B48,"N")*1 AND i TRIED COUNTIF(B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND i TRIED COUNTIF(NIGHT!B5:B36,"N")+COUNTIF(DAY!B5:B48,"N") AND ITS STILL NOT COUNTING THE ONES ON THE DAY WORKSHEET. HELP! "pdberger" wrote: Godzflava -- The easiest way is to add a similar expression, just selecting the cells on the other worksheet as you go. You'll probably end up with something like: =countif(B5:B48,"N")*1+COUNTIF('OtherSheet'!B4:B48 ,"N")*1 HTH "godzflava" wrote: I have a worksheet created that has "D" to represent Dayshift and "N" to represent the nightshift. I would like to create a formula in the total cell on the nightshift worksheet that would indicate the total for both worksheets that have any nightshift personnel. Here is the formula I have for the total on both worksheets: countif(B5:B48,"N")*1 Now how do I add the night shift on the other worksheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
Linking one worksheet to another by click on a command button | Excel Discussion (Misc queries) | |||
Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |