SumProduct Formula Help

[bountifulgrace]

I the following information:

In Row 14 are city names, In Column A, are item descriptions

I have data (numbers) in B15:AQ249.

I want to return the number in the range B15:AQ249 for a particula
city, however, when I use the SumProduct formula below, it returns th
total of the row, but I want just one number for a particular city.

How can I make this formula work?


=SUMPRODUCT((B14:AQ14="Bethesda")*0)+SUMPRODUCT((A15:A80=A4)*(B15:AQ80))


Thanks

T

 

[Bob Phillips]

=INDEX(B15:AQ80,MATCH(A4,A15:A80,0),MATCH("Bethesda",B14:AQ14,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bountifulgrace"

 

[bountifulgrace]

This works.

Thanks

=INDEX(B15:AQ80,MATCH(A4,A15:A80,0),MATCH("Bethesda",B14:AQ14,0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bountifulgrace"
messag

http://www.excelforum.com/showthread.php?threadid=538942