| 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 |
| 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 | |||
Threaded Mode
