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