| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Turn off or not include lines in a calculation
I have a spread sheet that has a formula at the bottom to count all cells
that have the work day. This calculation =COUNTIF(B7:O170,"DAY"). This counts all cells that have the word day. I want to exclude Lines 7, 10, 13, 16, 19 and so forth, only have the calculation for say every 3rd line. Is there a way to exclude certain lines in my calculation. Thanks for any help. -- DLAYMANS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Turn off or not include lines in a calculation
maybe (not tested)
=sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)=0)) "DLAYMANS" wrote: I have a spread sheet that has a formula at the bottom to count all cells that have the work day. This calculation =COUNTIF(B7:O170,"DAY"). This counts all cells that have the word day. I want to exclude Lines 7, 10, 13, 16, 19 and so forth, only have the calculation for say every 3rd line. Is there a way to exclude certain lines in my calculation. Thanks for any help. -- DLAYMANS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Turn off or not include lines in a calculation
oops, should be <
=sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)<0)) "Duke Carey" wrote: maybe (not tested) =sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)=0)) "DLAYMANS" wrote: I have a spread sheet that has a formula at the bottom to count all cells that have the work day. This calculation =COUNTIF(B7:O170,"DAY"). This counts all cells that have the word day. I want to exclude Lines 7, 10, 13, 16, 19 and so forth, only have the calculation for say every 3rd line. Is there a way to exclude certain lines in my calculation. Thanks for any help. -- DLAYMANS |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Turn off or not include lines in a calculation
Duke,, appreciate your help,, when I put the formula in, I get #value! in the
cell where I have the formula. Can you lead me a little further. What I have is a Spread sheet where we track fellows work record. We have several items that we show the man when he works or is off,, Rest, Off With Permission, Off Sick, ect. At the bottom of the sheet we have it total the items with the same data,, such as sick. Any help would be greatly appreciated. D -- DLAYMANS "Duke Carey" wrote: oops, should be < =sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)<0)) "Duke Carey" wrote: maybe (not tested) =sumproduct(--(B7:O170="DAY"),--(mod(row(B7:O170)-7,3)=0)) "DLAYMANS" wrote: I have a spread sheet that has a formula at the bottom to count all cells that have the work day. This calculation =COUNTIF(B7:O170,"DAY"). This counts all cells that have the word day. I want to exclude Lines 7, 10, 13, 16, 19 and so forth, only have the calculation for say every 3rd line. Is there a way to exclude certain lines in my calculation. Thanks for any help. -- DLAYMANS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i turn off calculation of cells | Excel Discussion (Misc queries) | |||
| Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
| Time Calculation For A Timesheet To Include Lunch | Excel Worksheet Functions | |||
| Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
| Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Linear Mode
