| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum values depending in values next column
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum values depending in values next column
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 D2:D5 -- Regards Roger Govier "luiss" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum values depending in values next column
Many thanks. Both solutions worked marvellously.
Luis "BenjieLop" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum values depending in values next column
Thanks for the feedback. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=558988 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| linking values of column A to values of column B | Excel Discussion (Misc queries) | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Hybrid Mode
