excel - Sum or Count until? -
i'm trying make compliance worksheet more efficient. have list of controls in sections (and sub-sections), , use value placeholder count number of controls per section (or sub-section), exceptions per section. use value "1" if there valid control, , sum these values per section or sub-section.
i have add rows bottom of section, , throws sum-formula off, requiring manual updating these formulas.
i utilize formula either "sum-until" or "count-until" next section. i've attached example.
is there way sum (or count) until next formula or non-"1"-value? easier put "end" value @ bottom of each of these sections, , count until "end"? wouldn't ideal way perform such function (as there number of unnecessary "ends" between sections), if there's not better way, perhaps i'll explore avenue.
use named range each section, when add row, add named range.
so name range 'section1' c3:c9, when add row, right click on row number 9, , 'insert', new row in 'section1'. can put formula in as
=sum(section1)
Comments
Post a Comment