Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #47

Compute a search, retrieve the Row IDs from the cells that match the search and add to them a column ID which has numbers pupulating it's cells to make it possible to perform a sum with these ranges of cells.

Show all headers | View raw

Example:

     A   B   C    D
1----*   2      
2----    4   
3----*   7   

The search term:

"*"

Cells that match the search:

"a1, a3"

Rows that matter:

"1, 3"

Column that matter:

"B"

Function:

=SUM("ID number of a row containing object that match the search"B, "ID number of another row containing object that match the search"B) — This outputs a number.



I know this is an unnusual approach, but is there anybody who can help me figure this out, or make it possible?

Back to comp.apps.spreadsheets | Previous | Next | Find similar

Thread

Compute a search, retrieve the Row IDs from the cells that match the search and add to them a column ID which has numbers pupulating it's cells to make it possible to perform a sum with these ranges of cells. n370 <dylsonvalenteneto@gmail.com> - 2013-01-21 18:50 -0800

csiph-web