I have to do a daily Excel spreadsheet, in an IT troubleshooting environment, which lists issues for the day and week, whether they are closed or open, and, for the closed issues, which of a half-dozen categories the resolutions fall into. The detail section comprises three parts–(1) issues currently open, (2) issues that have been closed today, and (3) issues closed since the beginning of the week, with the contents of (2) repeated.
Above the detail section is a set of totals based on the above, which we now do manually.
For each detail line I can create several numeric columns that populate automatically with 1 or 0 depending on what’s in the Resolution column. Over the entire spreadsheet, then, I could easily tell how many of the closed issues are, say, “Configuration” or “Data Setup” incidents, but the problem is, I need to be able to generate these totals only over certain vertical segments of the report, based on which of the three detail sections they fall, that I described above. I do know that I can name a cell on the horizontal divider “bars” and from that I can use the ROW function to get the row number for that row. But how can I then use the information provided by the named cells in the divider bars to determine which rows of a given column should be added?