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 particular
city, however, when I use the SumProduct formula below, it returns the
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((A 15:A80=A4)*(B15:AQ80))


Thanks

TR


--
bountifulgrace
------------------------------------------------------------------------
bountifulgrace's Profile: http://www.excelforum.com/member.php...o&userid=33237
View this thread: http://www.excelforum.com/showthread...hreadid=538942