vlookup combined with AND-function

M

martho

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
 
G

Guest

Hi

You could try something like:
=SUMPRODUCT((A1:A20="A")*(B1:B20="D")*(C1:C2))

Hope this helps.
Andy.
 
Top