Sum values depending in values next column

[Guest]

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

 

[Roger Govier]

Hi

One way
=SUMIF(B:B,"Hotel_required",A:A)

Better still, put the names of the hotels you want in say C1:C5 and
enter in D1
=SUMIF(B:B,C1,A:A)
Copy down through D25

 

[BenjieLop]

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.

 

[Guest]

Many thanks. Both solutions worked marvellously.

Luis

 

[BenjieLop]

Thanks for the feedback.

Regards.