Nothing is easy to do in a spreadsheet.
This prejudice is built upon deception because a spreadsheet lets you
enter anything anywhere instantly.
Have you tried SUBTOTAL with filters? What is wrong with it?
The infamous D-functions (DSUM, DGET, D...) can display subtotals based
on filter criteria while a filtered list uses the same criteria.
However, reading again your description...
each column would refer to an areas examined in a security assessment.
You are using some cross-table layout with a dynamic count of columns.
All the spreadsheet features below menu "Data" assume a normalized
layout, in fact a database table.
In a spreadsheet it is possible to gather aggregations from "wrong
tables", but it requires some heavy skills. Usually, the first step is a
normalization on a second sheet.
Long forum discussion with example sheets:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=14027
(I'm "Villeroy").
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
