View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
BenjieLop BenjieLop is offline
external usenet poster
 
Posts: 1
Default Sum values depending in values next column


luiss Wrote:
Hi,

In one column I have the rates of different hotels, and in the next
column I
have the names of the hotels. How can I sum all values for each hotel
without
using Filter (this does not update automatically)?

Thanks and regards

Luis Serpa


This is probably what you need:

=SUMPRODUCT((A1:A100)*(B1:B100=\"HOTEL NAME\")

where

A1:A100 is the column that contains the different hotel rates AND
B1:B100 is the column that contains the different hotel names.

NOTE: Modify your column range to suit your needs.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=558988