HLOOKUP assistance

350GTR

New Member
Joined
Oct 6, 2006
Messages
4
Hello fellow excel users. I have been trying to get HLOOKUP to work for me with no avail and am hoping that someone can assist me with my problem. Below is my situation:

helpsa5.jpg


What I am trying to do is the following:
- get the sum for "TM", "Other" and "Internet" each time that field is selected from the drop down list.

I was hoping HLOOKUP would do the job but I can not seem to get it to work unless I am using the incorrect function or not adding additonal information. Please assist...anyone??
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

350GTR

New Member
Joined
Oct 6, 2006
Messages
4
I apologize for leaving out some additional information.

- Categories labled as TM, Internet and Other are from a drop-down list on rows B3:K3
- These categories are represented with an amount on rows B4:K4

On column B18:B20, I am attempting to get the sum for each category amount when selected from the drop-down list
TM ? I know from adding it should be $1,085,250
Internet ? I know from adding it should be $275,000
Other ? I know from adding it should be $1,374,613
(Please see original screenshot from my first post)


How can I get HLOOKUP to sum these figures up for me without me manually adding them? Any suggestions???
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
I apologize for leaving out some additional information.

- Categories labled as TM, Internet and Other are from a drop-down list on rows B3:K3
- These categories are represented with an amount on rows B4:K4

On column B18:B20, I am attempting to get the sum for each category amount when selected from the drop-down list
TM ? I know from adding it should be $1,085,250
Internet ? I know from adding it should be $275,000
Other ? I know from adding it should be $1,374,613
(Please see original screenshot from my first post)


How can I get HLOOKUP to sum these figures up for me without me manually adding them? Any suggestions???

=SUMIF($B$3:$K$3,"TM",$B$4:$K$4)
 

Forum statistics

Threads
1,140,937
Messages
5,703,256
Members
421,289
Latest member
fbohlandt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top