X-Received: by 10.224.175.65 with SMTP id w1mr11715351qaz.7.1358823002356; Mon, 21 Jan 2013 18:50:02 -0800 (PST)
X-Received: by 10.49.15.38 with SMTP id u6mr4275253qec.8.1358823002339; Mon, 21 Jan 2013 18:50:02 -0800 (PST)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!p13no5841501qai.0!news-out.google.com!k2ni1457qap.0!nntp.google.com!p13no4025790qai.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.apps.spreadsheets
Date: Mon, 21 Jan 2013 18:50:02 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=186.221.247.193; posting-account=fn_omQoAAABIsmHqDRwzH9O5nJDTbTki
NNTP-Posting-Host: 186.221.247.193
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <6355ad41-7712-4d4f-999e-5aaad385e866@googlegroups.com>
Subject: 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.
From: n370 <dylsonvalenteneto@gmail.com>
Injection-Date: Tue, 22 Jan 2013 02:50:02 +0000
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com comp.apps.spreadsheets:47

Example:

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

The search term:

"*"

Cells that match the search:

"a1, a3"

Rows that matter:

"1, 3"

Column that matter:

"B"

Function:

=3DSUM("ID number of a row containing object that match the search"B, "ID n=
umber of another row containing object that match the search"B) =97 This ou=
tputs a number.



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