Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
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.
8 views
Skip to first unread message
n370
Jan 21, 2013, 9:50:02 PM1/21/13
to
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?
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?
0 new messages