software

i got the result from a calculation in form of an unformatted table.
example with distances, like point A to point B:

A B 1.23
A C 2.45
A D 3.52
B F 5.67

How should the formula look like to get the numbers from Point A to D?

Any help is very much appreciated
Regards--
martho
------------------------------------------------------------------------
martho's Profile: www.excelforum.com/member.php...oamp;userid=29144
View this thread: www.excelforum.com/showthread...hreadid=503293Hi

You could try something like:
=SUMPRODUCT((A1:A20=quot;Aquot;)*(B1:B20=quot;Dquot;)*(C1:C2))

Hope this helps.
Andy.

quot;marthoquot; gt; wrote in
message ...
gt;
gt; i got the result from a calculation in form of an unformatted table.
gt; example with distances, like point A to point B:
gt;
gt; A B 1.23
gt; A C 2.45
gt; A D 3.52
gt; B F 5.67
gt;
gt; How should the formula look like to get the numbers from Point A to D?
gt;
gt; Any help is very much appreciated
gt; Regards
gt;
gt;
gt; --
gt; martho
gt; ------------------------------------------------------------------------
gt; martho's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29144
gt; View this thread: www.excelforum.com/showthread...hreadid=503293
gt;